• There is an excellent article on the SQLServerCentral home page today on that very subject:

    http://www.sqlservercentral.com/articles/delete/96780/

    Be sure to read the discussion on the article, since it has some alternative methods and additional considerations for large volume deletes.


    And then again, I might be wrong ...
    David Webb