Refreshing Tables with Less Interruption
I talk about using partition switching to load in fresh versions of staging tables with the least impact to current users.
Monthly Archive: September 2021
Consolidating links and resources
I made some landing pages here, with simple and easy-to-remember URLs, presenting sets of links to very frequently-discussed topics around SQL Server.
SQL Server 2017 Cumulative Update #26
SQL Server 2017 Cumulative Update #26 is available, with 31 enhancements. The build number is 14.0.3411.3.
Why I don't like the WHILE (1=1) pattern
In this tip, I discuss one way to help avoid infinite loops in common while loop patterns.
Finding problematic NOLOCK patterns – Part 4
In part 4, I show how to include ad hoc DML queries in the analysis.