Dear Sql Dba

Why You Should Switch in Staging Tables Instead of Renaming Them

Informações:

Sinopse

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