Simple Parameterization and Trivial Plans — Part 4 Paul White continues his series explaining how the parser affects simple parameterization and trivial plans. Learn more in part 4. Paul White ◆ May 20, 2022 0
Simple Parameterization and Trivial Plans — Part 3 Paul White continues his series on simple parameterization and trivial plans with a look at the information available in execution plans. Paul White ◆ April 18, 2022 2
Simple Parameterization and Trivial Plans — Part 2 Paul White continues his series on simple parameterization and trivial plans with a look at the data types assigned to parameters. Learn more in part 2. Paul White ◆ March 29, 2022 0
Simple Parameterization and Trivial Plans — Part 1 Paul White embarks on a new series covering less well-known details about simple parameterization and trivial plans. Learn more in part 1. Paul White ◆ March 22, 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