T-SQL: Switching data with a Single Partition

This is the fastest way to move data to a new table. Of course, you have to move all the data, but it’s quite useful. Tables are partitioned in SQL by default so this is a great technique.