I'm testing out the duration as well now for the bcp out, truncate and bcp in.

With the drop constraint with Move to another partition is just taking forever as...

Thanks a lot for all the replies.

I really like the idea of having the date column and using it as the partition column. The first idea was...