Home Forums Article Discussions Article Discussions by Author Discuss content posted by Ted Pin Deleting batches of rows with TOP RE: Deleting batches of rows with TOP

  • July 3, 2008 at 9:48 am

    #837952

    cjeremy74 (7/3/2008)

    Anirban Paul (7/3/2008)

    Is these one practically useful? I have a doubt. Any comments on these?

    I actually did use this about a month ago... we had a new policy implemented that allowed us to delete a couple of years worth of data out of several audit tables. The largest delete was approx 2.5 million rows. Agreed probably not an every day use, but does get us less experienced DBA's thinking beyond getting something to just work.

    Thanks for the info... May be this will be helpful for me one day.