The SQL Server Transaction Log, Part 4: Log Records Paul Randal continues his series on the SQL Server transaction log, this time describing the internals of log records. Paul Randal ◆ July 19, 2022 6
The SQL Server Transaction Log, Part 3: The Circular Nature of the Log Paul Randal continues his series on the SQL Server transaction log, discussing its circular nature and the challenges involved. Learn more. Paul Randal ◆ April 5, 2022 3
The SQL Server Transaction Log, Part 2: Log Architecture Paul Randal lays some groundwork around the architecture of the SQL Server transaction log. Paul Randal ◆ February 1, 2022 2
The SQL Server Transaction Log, Part 1: Logging Basics Paul Randal starts a new blog series to dive deep into every aspect of the SQL Server transaction log. Paul Randal ◆ January 20, 2022 5
Why the Optimizer Doesn't Use Buffer Pool Knowledge Paul Randal describes why the optimizer doesn’t use buffer pool contents for plan generation and details the potential dangers if it did. Paul Randal ◆ November 30, 2021 4
Tracking Synchronous Statistics Updates Paul Randal reveals a new wait for tracking statistics updates, explains why it might not always be reliable, and shows a potential workaround. Paul Randal ◆ October 26, 2021 5
SQL Server Latches – Other Latches To Know About Paul Randal closes out his series on latch bottlenecks in SQL Server. Paul Randal ◆ September 16, 2021 0
The APPEND_ONLY_STORAGE_INSERT_POINT Latch In his ongoing series on latches, Paul Randal explores a latch you may experience in write-heavy workloads involving snapshot isolation levels. Paul Randal ◆ August 27, 2021 2
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
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
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
