Articles

Page 3 of 10 — showing articles 37 to 54 of 177

SQL Server 2019 Aggregate Splitting

Splitting in Progress

Exploring a new query optimizer exploration rule in SQL Server 2019 can split large batch mode hash aggregates to avoid or reduce spilling to tempdb.

How MAXDOP Really Works

Processors at Work

A MAXDOP n hint does not limit a SQL Server execution plan to using a maximum of n CPU cores concurrently 🤯

Finding Distinct Values Quickly

Japanese Water Garden

A few different ways to retrieve distinct values from a table, including some big "it just runs faster" wins in SQL Server 2019.

Batch Mode Bitmap Demos

Bitmap

Demo scripts for SQL Server batch mode hash bitmap selectivity estimates. Simple and complex bitmap types. Compiled and compressed bitmaps.

Batch Mode Bitmaps in SQL Server

Bitmap

A deep dive into SQL Server batch mode bitmaps revealing undocumented details that can greatly impact performance.

Apply versus Nested Loops Join

Nested Loops

Understanding the differences between SQL Server APPLY and nested loops joins, including details of query optimizer transformations.

Columnstore Grouped Aggregate Pushdown

Group Pushdown

A deep dive into columnstore grouped aggregation pushdown, showing where this optimization is unsuccessful or not attempted, using the undocumented SQL Server command DBCC CSINDEX.