We have a partitioned table with around 5m records in each partition.
This table has total 60 partitions, out of these 20 partitions we want to merge.
The merge takes lot of time as the partitions are not empty.
Is there any fast method to merge the non-empty partitions?
I am not an expert in partitioning, but my coworker is. :)
She recommended copying the data to another table and then switching that table into the original one.
Here's the official TechNet explanation: http://technet.microsoft.com/en-us/library/ms191160.aspx
And here's a good explanation at sqlservercentral.com: http://www.sqlservercentral.com/articles/partition/64740/
