Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Delete large data from live table Expand / Collapse
Author
Message
Posted Wednesday, March 6, 2013 2:48 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, September 17, 2013 2:07 PM
Points: 171, Visits: 556
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
Post #1427645
Posted Wednesday, March 6, 2013 2:58 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, December 19, 2014 2:37 PM
Points: 867, Visits: 7,574
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
Post #1427651
Posted Wednesday, March 6, 2013 10:19 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 7:02 PM
Points: 20,862, Visits: 32,893
Or this one: http://www.sqlservercentral.com/articles/T-SQL/67898/.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1427767
Posted Thursday, March 7, 2013 12:18 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 5:31 AM
Points: 2,841, Visits: 3,985
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
Post #1427805
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse