Learn how to approach the unexpected in a mysterious execution plan that contains way more operators than expected for a very simple SQL Server query.

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