As soon as you open a SQL connection in the query analyzer, what resources (worker threads, etc) are assigned from SQL Server system perspective? How do I know how much and what is assigned? I am talking about while in Idle and not running any queries
vs you already ran the query and sitting there..
View Complete Post