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 Plans   (RSS)
  • Beware Sneaky Reads with Unique Indexes

    A few days ago, Sandra Mueller (twitter | blog) asked a question using twitter’s #sqlhelp hash tag: “Might SQL Server retrieve (out-of-row) LOB data from a table, even if the column isn’t referenced in the query?” Leaving aside trivial cases (like selecting a computed column that does reference the LOB data), one might be tempted to say ...
    Posted to Page Free Space (Weblog) by Paul White on December 13, 2010
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement