Thanks, yeah I did it a while ago on the same file group took only 1 to 2 seconds to transfer data from one table to another.

I'm trying to a split on the partition but the upper boundary has already been reached and there are around 228641887 rows on the 5th partition.

I ran the split for 15 mins but it did not complete. How long should I wait ?

My VM has SSDs on it.