Simple Parameterization and Trivial Plans — Part 6 Paul White concludes his series with trivial plans and when simple parameterization is considered safe or unsafe. Paul White ◆ August 4, 2022 0
The Adaptive Join Threshold Paul White discusses how an adaptive join decides to use a batch mode hash join or row mode apply and includes details of the threshold calculation. Paul White ◆ November 4, 2021 0
How Parallel Plans Start Up – Part 5 Paul White concludes his series on starting parallel plans, summarizing how additional parallel tasks cooperate to complete plan execution. Paul White ◆ May 17, 2021 0
How Parallel Plans Start Up – Part 4 Paul White continues his deep dive into parallel plans. Part 4 covers exchange synchronization, CXPACKET waits, and parallel task opening. Paul White ◆ May 6, 2021 0
How Parallel Plans Start Up – Part 3 Part 3 of Paul White's series on parallel plans, explaining "early phases", how parallel tasks are added, and when plan timing data is set. Paul White ◆ April 20, 2021 0
How Parallel Plans Start Up – Part 2 Paul White continues his deep dive into parallel plans, explaining iterative execution, invisible profilers, and how the query scan begins. Paul White ◆ April 8, 2021 0
How Parallel Plans Start Up – Part 1 Paul White takes a deep dive into the way parallel plans start up, including the role of the parent task (coordinator) in plan execution. Paul White ◆ March 30, 2021 2
Understanding Execution Plan Operator Timings How SQL Server actual execution plan operator timings work, and why parallel row mode plan timings can be misleading, by Paul White. Paul White ◆ March 8, 2021 3
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
Nested Loops Joins and Performance Spools Paul White on performance spools, and how they can be used by the optimizer to reduce the estimated cost of nested loops joins. Paul White ◆ September 25, 2019 2
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