A use case for sp_prepare / sp_prepexec Aaron Bertrand explains a scenario where sp_prepare came in handy trying to validate a plan guide's impact. Aaron Bertrand ◆ January 11, 2021 0
When Do SQL Server Sorts Rewind? Paul White explains when a SQL Server sort operator inside a loop rewinds (replays) cached results to avoid re-executing plan operators. Paul White ◆ October 7, 2020 0
The Eager Index Spool and The Optimizer Paul White looks at the Eager Index Spool execution plan operator, and the optimizer rules capable of adding it into plans. Paul White ◆ November 22, 2019 0
Batch Mode Normalization and Performance Paul White takes a deep-dive look at the internals of batch mode data normalization and how it can affect execution plans and performance. Paul White ◆ September 5, 2019 1
Batch Mode Bitmaps in SQL Server Paul White takes a deep dive into SQL Server batch mode bitmaps revealing undocumented details that can greatly impact performance. Paul White ◆ August 23, 2019 3
Some ANY Aggregate Transformations are Broken Paul White explores two cases where the introduction of the internal ANY aggregate by the optimizer may cause wrong results. Paul White ◆ July 1, 2019 8
Minimal Logging with INSERT…SELECT and Fast Load Context Paul White explains minimal logging for inserts into b-tree indexes using Fast Load Context, and why it might not always work as expected. Paul White ◆ May 29, 2019 0
Examining the Performance Impact of an Adhoc Workload Erin Stellato discusses the performance impact of a predominately adhoc workload in SQL Server. Erin Stellato ◆ May 22, 2019 3
Minimal Logging with INSERT…SELECT into Empty Clustered Tables Paul White explains in detail the factors SQL Server considers when enabling minimal logging for inserts into an empty clustered table. Paul White ◆ May 16, 2019 0
Minimal Logging with INSERT…SELECT into Heap Tables Paul White explains in detail the factors SQL Server considers when enabling minimal logging for inserts into a table without a clustered index. Paul White ◆ May 1, 2019 5
Grouped Aggregate Pushdown Paul White goes deep on grouped aggregation pushdown, and explains examples where this optimization is unsuccessful or simply not attempted, using the undocumented command DBCC CSINDEX. Paul White ◆ April 23, 2019 0