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 06, 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 06, 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: Today @ 10:56 AM
Points: 893, Visits: 6,884
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 06, 2013 10:19 PM


SSC-Insane

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

Group: General Forum Members
Last Login: Today @ 11:18 AM
Points: 22,492, Visits: 30,188
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 07, 2013 12:18 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, March 14, 2014 2:19 AM
Points: 2,820, Visits: 3,916
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