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
