• Hi Zach, I think thats a pretty neat approach.

    With large tables I prefer to use table partitioning, which gets around the issue of locking a live table for an extended period of time, and improves query performance etc. I can see how your method would be benefitial for non-partitioned tables though.

    Cheers for the article.