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
Sunday, 15 September 2024
Current State of the ANY Aggregate Transformation
›
This article was originally published on 𝕏. SQL Server provides a way to select any one row from a group of rows, provided you write the...
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
