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 1
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 29
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 5
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
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
