Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Delete large volume of data from database

Author  Topic 

mathai88
Starting Member

1 Post

Posted - 2012-10-23 : 00:32:56
Hi,
I want to delete about 250 mil of data from database. My database have 98 tables. So can you please suggest me an efficient method to delete large volume of data.....

Pls....

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2012-10-23 : 01:41:26
1) Is it the full table? or are you using SELECT statements to delete only a portion of the table?
The question is : do you need to delete rows or truncate\drop tables?

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

prett
Posting Yak Master

212 Posts

Posted - 2012-10-23 : 06:27:17
I found a good article on this topic, please check it from here: http://www.sqlservercentral.com/articles/T-SQL/67898/
Go to Top of Page

marian.vacek
Starting Member

1 Post

Posted - 2014-12-03 : 08:29:03
find information here unspammed
good luck)
Go to Top of Page
   

- Advertisement -