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.
I talk about using partition switching to load in fresh versions of staging tables with the least impact to current users.
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 is available, with 31 enhancements. The build number is 14.0.3411.3.
In this tip, I discuss one way to help avoid infinite loops in common while loop patterns.
In part 4, I show how to include ad hoc DML queries in the analysis.