Delete large data from live table

• komal145

  SSCrazy Eights

  Points: 9915

  More actions

  March 6, 2013 at 2:48 pm

  #274885

  I have to delete data from live table( Size of DB:terabytes) (system is becoming slow).

  without affecting the end users ?

  And tables have indexes and identity columns.( when I delete , I don't want to affect the identity columns, how can we do it?)

  It is taking lot of time to delete the data.How can i do that?

  Any steps to follow.

  Thanks

  Komal

• David Webb-CDS

  SSCoach

  Points: 17398

  More actions

  March 6, 2013 at 2:58 pm

  #1594178

  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

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  March 6, 2013 at 10:19 pm

  #1594277

  Or this one: http://www.sqlservercentral.com/articles/T-SQL/67898/.

• Bhuvnesh

  SSC Guru

  Points: 59351

  More actions

  March 7, 2013 at 12:18 am

  #1594307

  komal145 (3/6/2013)

  ---

  when I delete , I don't want to affect the identity columns, how can we do it?

  Can you elaborate this ?

  -------Bhuvnesh----------
  I work only to learn Sql Server...though my company pays me for getting their stuff done;-)