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 10
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
Deprecated features to take out of your toolbox – Part 1 Aaron Bertrand provides evidence about SQL Server features you should stop using, like sysprocesses, but not just because they've been deprecated. Aaron Bertrand ◆ February 22, 2021 3
How to Write a Query with Multiple Behaviors Guy Glanster explores the multiple behaviors of queries designed to support user-specified filtering and sorting. Guy Glanster ◆ February 16, 2021 1
Number series generator challenge solutions – Part 2 Itzik Ben-Gan digs deeper into reader submissions to a recent challenge for an efficient number series generator. Itzik Ben-Gan ◆ February 10, 2021 13
