Comments (7)

  1. Nice man, this was very helpful for me. I’ve ran into the situations on numerous occasions of items past where they tried to outsmart the optimizer. Sometimes I believe if we worked a bit smarter situations could be avoided like that. Have a good one

    1. Thanks, Chris. I love index hints for testing different plans, but not in production. :)

  2. […] Why is Your SQL Server Slow? Here’s a Hint – Robert L. Davis(Blog|Twitter) […]

  3. […] L. Soldier’s Why is Your SQL Server Slow? Here’s a Hint and Why is Your SQL Server Slow? All-for-one and One-for-all provide suggestions on things that […]

  4. My favorite query hint is NOLOCK. It fixes everything!

    Just kidding :-)

    Good post. Should be a must read for all SQL Developers and DBAs.

Leave a Reply

Your email address will not be published. Required fields are marked *