THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » sql » query performance   (RSS)
  • Override the optimizer or give it an easy task?

    When your query must always return in a certain amount of time, trusting the optimizer might not be the best choice. Suppose your select must return in one second no matter what, and it usually returns in 50 ms, but sometimes, once in 100K calls, it takes full five seconds to complete, and clearly such query does not meet the requirement to ...
    Posted to Alexander Kuznetsov (Weblog) by Alexander Kuznetsov on June 16, 2009
Privacy Statement