From: Bero on
Why is SQL Server 2005 open 40-50 threads for same SPID for a given
database at times and goes back to sleep and will have only 2-3 threds
per SPID at other times. How does SQL Server processes when you issue
rebuild indexes via MP?