The Lock Escalation Threshold – Part 3 In the third part of his series on lock escalation, Paul White discusses how long SQL Server holds locks and why. Paul White ◆ October 20, 2022 0
The Lock Escalation Threshold – Part 2 Paul White continues his series on lock escalation by diving into the mechanics involving parallelism. Paul White ◆ October 4, 2022 0
The Lock Escalation Threshold – Part 1 Paul White explains how and when lock escalation is triggered in SQL Server, clarifying misleading information you may have seen in official documentation and other sources. Paul White ◆ September 6, 2022 1
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
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