Delete large data from live table

Click here to monitor SSC

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>

SQLServerCentral is supported by Red Gate Software Ltd.

Log in :: Register :: Not logged in

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>

Recent Posts

Popular Topics

Home

Home » SQL Server 2008 » T-SQL (SS2K8) » Delete large data from live table

Add to briefcase

Delete large data from live table

Expand / Collapse

Author

Message

Posted Wednesday, March 06, 2013 2:48 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, March 19, 2013 1:38 PM
Points: 168, Visits: 540

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!

Group: General Forum Members
Last Login: Yesterday @ 10:19 AM
Points: 834, Visits: 5,839

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

Group: General Forum Members
Last Login: Yesterday @ 11:14 PM
Points: 21,832, Visits: 27,862

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

Cool

Cool

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

Group: General Forum Members
Last Login: Thursday, June 13, 2013 7:03 AM
Points: 2,562, Visits: 3,453

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----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post

Post #1427805

« Prev Topic | Next Topic »

Add to briefcase

Permissions

Expand / Collapse