Page Free Space

SQL Server 2019 Aggregate Splitting The SQL Server 2019 query optimizer has a new trick available to improve the perfor...

Cardinality Estimation for Disjunctive Predicates in SQL Server 2014 Introduction Back in January 2014, I wrote an art...

Working Around Missed Optimizations In my last post , we saw how a query featuring a scalar aggregate could be transfor...

Hello Operator, My Switch Is Bored This post is in two parts. The first part looks at the Switch execution plan operato...

Cardinality Estimation Bug with Lookups Estimated row counts on Key or RID Lookups where a filtering predicate is app...

Heaps of Trouble? Brad Schulz recently wrote about optimizing a query run against tables with no indexes at all . The...