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 » Spool   (RSS)
  • Ranking Function Optimizer Transformations

    In my last post I showed how SQL Server 2005 and later can use a Segment Spool to efficiently implement aggregate window functions and the NTILE ranking function. The query optimizer is also smart enough to recognise that some queries are logically equivalent to a window function, even if they are written using different syntax.  As a ...
    Posted to Paul White: Page Free Space (Weblog) by Paul White on July 28, 2010
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement