Why You Should Switch in Staging Tables Instead of Renaming Them

Dear SQL DBA - A podcast by Kendra Little

Categories:

Technology

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