Phil Parkin (10/25/2016)
wtren (10/25/2016)
You should use bcpPlease justify this comment.
Although it was a bit short, it's not a bad idea. I've done similar before. Instead of messing around with loops and all manner of other tricks, you BCP the data out as native format (very fast) and then BCP or BULK INSERT it back in where you want it. If you hold your mouth just right while you're doing it (especially with TF 610), you can even do it in a minimally logged fashion with the Clustered Index already in place.
--Jeff Moden
Change is inevitable... Change for the better is not.