I talk about using partition switching to load in fresh versions of staging tables with the least impact to 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.

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.