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
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
Fundamentals of Table Expressions, Part 13 – Inline Table-Valued Functions, Continued Itzik Ben-Gan concludes his series on table expressions in SQL Server, explaining more internals of inline table-valued functions. Itzik Ben-Gan ◆ November 10, 2021 2
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
Bad Habits: Avoiding NULL in SQL Server Aaron Bertrand talks about NULLs, the logical issues with avoiding them, and potential performance impacts. Aaron Bertrand ◆ October 21, 2021 1
Fundamentals of Table Expressions, Part 12 – Inline Table-Valued Functions Itzik Ben-Gan continues his blog series on table expressions in SQL Server, this time digging into inline table-valued functions (iTVFs). Itzik Ben-Gan ◆ October 13, 2021 4
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
Fundamentals of Table Expressions, Part 11 – Views, Modification Considerations Itzik Ben-Gan returns to his table expressions series, covering what you need to think about when using a view to modify its underlying table(s). Itzik Ben-Gan ◆ September 8, 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