THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web
Browse by Tags
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 ...
Paul White: Page Free Space
July 28, 2010
Brought to you by