Why You Should Switch in Staging Tables Instead of Renaming Them (Dear SQL DBA Episode 26)
Category:
query-performance
, sql-server
Over the years, I’ve come across a pattern fairly frequently: an application in an OLTP database periodically creates new tables, loads some data into them and fixes it up, then does a switcheroo and replaces old tables with the new tables.
This can cause major problems with blocking if anyone else is querying the table.