Forum Replies Created

Viewing 3 posts - 46 through 48 (of 48 total)

  • RE: Query Performance Tuning

    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!

  • RE: Query Performance Tuning

    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...

  • RE: Query Performance Tuning

    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,...

Viewing 3 posts - 46 through 48 (of 48 total)