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.
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 |
|
|
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/ |
|
|
marian.vacek
Starting Member
1 Post |
Posted - 2014-12-03 : 08:29:03
|
find information here unspammedgood luck) |
|
|
|
|
|