The DBCC_OBJECT_METADATA Latch Paul Randal continues his series on latches, showing how computed columns can really slow down DBCC operations. Paul Randal ◆ July 27, 2021 1
UI Design Patterns That Don't Scale Michael J Swart takes a look at a few common UI design patterns that don't necessarily scale well with SQL Server. Guest Posts ◆ July 8, 2021 1
Deprecated features to take out of your toolbox – Part 3 As part of a long game on deprecated SQL Server functionality, Aaron Bertrand questions why anyone is still using text / ntext / image. Aaron Bertrand ◆ July 1, 2021 0
The FGCB_ADD_REMOVE Latch In his series on latches, Paul Randal dives deep on the mechanics of the FGCB_ADD_REMOVE latch class. Paul Randal ◆ June 22, 2021 3
Foreign Keys, Blocking, and Update Conflicts Paul White looks at foreign key blocking under read committed snapshot isolation, and related update conflicts under snapshot isolation. Paul White ◆ June 17, 2021 9
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 8
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
