Page Free Space
SQL Server internals by Paul White
Showing posts with label
Cardinality
.
Show all posts
Showing posts with label
Cardinality
.
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:
Tuesday 15 April 2014
Cardinality Estimation for Disjunctive (OR) Predicates in SQL Server 2014 Onward
›
Cardinality Estimation for Disjunctive Predicates in SQL Server 2014 Introduction Back in January 2014, I wrote an art...
Monday 8 July 2013
Working Around Missed Optimizations
›
Working Around Missed Optimizations In my last post , we saw how a query featuring a scalar aggregate could be transfor...
Tuesday 11 June 2013
Hello Operator, My Switch Is Bored
›
Hello Operator, My Switch Is Bored This post is in two parts. The first part looks at the Switch execution plan operato...
Monday 15 October 2012
Cardinality Estimation Bug with Lookups
›
Cardinality Estimation Bug with Lookups Estimated row counts on Key or RID Lookups where a filtering predicate is app...
Friday 10 December 2010
Heaps of Trouble?
›
Heaps of Trouble? Brad Schulz recently wrote about optimizing a query run against tables with no indexes at all . The...
›
Home
View web version