Viewing 3 posts - 46 through 48 (of 48 total)
I like what you are saying, Grant.
I'm not familiar with the term "wait state" info. Is this something out of MSSQL, or from Perfmon or something?
Thanks!
April 4, 2011 at 1:05 pm
#1307142
Grant Fritchey (4/4/2011) since "slow" in this case is 300ms
Tell me about it. Not a good one to really cut my teeth on.
The Tuning Advisor recommended my covered index...
April 4, 2011 at 10:37 am
#1307071
Really? I was under the impression that if all the parameters in the query (WHERE clause) are covered by the index, that same index would be used every time,...
April 4, 2011 at 7:37 am
#1306971