THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » Query Plans » Cardinality   (RSS)
  • Cardinality Estimation Bug with Lookups

    Estimated row counts on key or RID lookups where a filtering predicate is applied can be wrong in SSMS execution plans.  This error does not affect the optimizer’s ultimate plan selection, but it does look odd.  There are other cases where estimated row counts are inconsistent (for defensible reasons) but the behaviour shown in this post ...
    Posted to Paul White: Page Free Space (Weblog) by Paul White on October 15, 2012
  • Heaps of Trouble?

    If you’re not already a regular reader of Brad Schulz’s blog, you’re missing out on some great material.  In his latest entry, he is tasked with optimizing a query run against tables that have no indexes at all.  The problem is, predictably, that performance is not very good.  The catch is that we are not allowed to create any ...
    Posted to Paul White: Page Free Space (Weblog) by Paul White on December 9, 2010
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement