Andrew Pruski demonstrates a gotcha when switching partitions between tables:
When working with partitioning the SWITCH operation has to be my favourite. The ability to move a large amount of data from one table to another as a META DATA ONLY operation is absolutely fantastic.
What’s also cool is that we can switch data into a non-partitioned table. Makes life a bit easier not having to manage two sets of partitions!
However, there is a bit of a gotcha when doing this. Let’s run through a quick demo.
Read on for more.