String Aggregation Over the Years in SQL Server Aaron Bertrand talks about progress in string aggregation—both in the functionality offered by SQL Server and the quality of his own code samples. Aaron Bertrand ◆ February 17, 2022 3
Matching Supply With Demand — Solutions, Part 2 Itzik Ben-Gan continues exploring solutions to a T-SQL challenge involving matching supply with demand. Itzik Ben-Gan ◆ February 9, 2022 4
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
Matching Supply With Demand — Solutions, Part 1 Itzik Ben-Gan presents initial solutions to his latest T-SQL challenge surrounding auctions (supply and demand). Itzik Ben-Gan ◆ January 12, 2022 2
Matching Supply With Demand Challenge Itzik Ben-Gan starts another T-SQL challenge series, this one about matching supply with demand (for example, an auction). Itzik Ben-Gan ◆ December 8, 2021 33
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
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 8
Refreshing SQL Server Tables With Less Interruption Using Partition Switching Aaron Bertrand talks about using partition switching to load refreshed SQL Server tables without impacting current users. Aaron Bertrand ◆ September 29, 2021 3
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
Split strings the right way – or the next best way Aaron Bertrand (@AaronBertrand) explores some common approaches people use to split strings, complete with performance analysis. Aaron Bertrand ◆ September 2, 2021 25
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
