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 » Internals » LOBs » Query Optimizer   (RSS)
  • Advanced TSQL Tuning: Why Internals Knowledge Matters

    There is much more to query tuning than reducing logical reads and adding covering nonclustered indexes.  Query tuning is not complete as soon as the query returns results quickly in the development or test environments.  In production, your query will compete for memory, CPU, locks, I/O and other resources on the server.  Today’s ...
    Posted to Page Free Space (Weblog) by Paul White on February 22, 2011
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement