Page Free Space
SQL Server internals by Paul White
Showing posts with label
Transformations
.
Show all posts
Showing posts with label
Transformations
.
Show all posts
Tuesday 4 August 2020
SQL Server 2019 Aggregate Splitting
›
SQL Server 2019 Aggregate Splitting The SQL Server 2019 query optimizer has a new trick available to improve the perfor...
2 comments:
Sunday 31 May 2020
Pulling Group By Above a Join
›
Pulling Group By Above a Join One of the transformations available to the SQL Server query optimizer is pulling a logic...
Sunday 4 December 2011
Is Distinct Aggregation Still Considered Harmful?
›
Is Distinct Aggregation Still Considered Harmful? Back in 2008, Marc Friedman of the SQL Server Query Processor Team wr...
Wednesday 28 July 2010
Ranking Function Optimizer Transformations
›
Ranking Function Optimizer Transformations In my last post I showed how SQL Server 2005 and later can use a Segment ...
›
Home
View web version