• Clever use of partition switching!

    Note that BOL warns that the transfer could introduce duplication in the identity column and recommends running DBCC CHECKIDENT (presumably after the switch).

    I recommend further reading BOL's article "Transferring Data Efficiently by Using Partition Switching" also available online in

    Technet: http://technet.microsoft.com/en-us/library/ms191160.aspx