Table swapping switcheroo (PARTITION SWITCH)

I love finding an obscure, rarely talked about feature in SQL Server, and today that is ALTER TABLE...SWITCH PARTITION I was working with a query that was doing several calculations and would take 10- 15 seconds to complete. It was being executed 20-30 times a minute by different users and was causing problems... BLOCKING...eating up CPU...just … Continue reading Table swapping switcheroo (PARTITION SWITCH)