<p>Performing a switcharoo between new and old tables can cause blocking nightmares. Partition switching may help, surprisingly even on non-partitioned tables.</p>

Performing a switcharoo between new and old tables can cause blocking nightmares. Partition switching may help, surprisingly even on non-partitioned tables.

Why You Should Switch in Staging Tables Instead of Renaming Them

Kendra Little's podcast discussing database performance tuning, software development, and working with data.

Share Why You Should Switch in Staging Tables Instead of Renaming Them

Sign up to save your podcasts

Why You Should Switch in Staging Tables Instead of Renaming Them

Why You Should Switch in Staging Tables Instead of Renaming Them

More shows like Dear SQL DBA

SQL Server Radio