Fundamentals of table expressions, Part 9 – Views, compared with derived tables and CTEs Itzik resumes his series on table expression fundamentals, this time comparing views to CTEs and derived tables. Itzik Ben-Gan ◆ June 9, 2021 2
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
Number series generator challenge solutions – Part 5 Itzik closes out his series exploring user-submitted functions for the number generator challenge, with two recommended solutions. Itzik Ben-Gan ◆ May 12, 2021 3
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
Introduction to Latches Paul Randal starts a new series exploring the reasons latches exist in SQL Server, the problems they can cause, and solutions you can use. Paul Randal ◆ May 3, 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
Number series generator challenge solutions – Part 4 Itzik Ben-Gan continues collaborating with readers to squeeze every ounce of performance out of a number series generator function. Itzik Ben-Gan ◆ April 14, 2021 13
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
Deprecated features to take out of your toolbox – Part 2 With a real-world example, Aaron Bertrand discusses why you shouldn't use deprecated functionality like SQL Server Profiler. Aaron Bertrand ◆ March 15, 2021 4
Number series generator challenge solutions – Part 3 Itzik Ben-Gan continues working with several readers to squeeze all the performance he can out of a number series generator. Itzik Ben-Gan ◆ March 10, 2021 9
