Dear SQL DBA
Dear SQL DBA
Kendra Little
Why You Should Switch in Staging Tables Instead of Renaming Them
11 minutes Posted Jan 19, 2017 at 11:00 am.
0:00
11:24
Download MP3
Show notes

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