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 Optimizer » Cardinality   (RSS)
  • Cardinality Estimation for Disjunctive Predicates in SQL Server 2014

    Introduction Back in January 2014, I wrote an article for SQLperformance.com describing the cardinality estimation process for queries with multiple predicates, from the point of view of the old and new cardinality estimators. The article describes the various behaviours and formulas involved, along with the usual sprinkling of documented and ...
    Posted to Paul White: Page Free Space (Weblog) by Paul White on April 15, 2014
  • 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