Lynn Pettis (9/19/2012)
If you are adding and deleting nearly 2,000,000 rows of data, then partitioning may be the what is needed for the archiving process. Depending on the data, it may be possible to establish a slinding window scenerio for quickly archiving data.
+1
With partitioning you will be able to truncate the data rather than deleting it from the table. So it will also avoid generating that much transaction log that it is generated with current DELETE operation.