|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Stop making mediocre tutorials.The best tutorials are video! Camtasia Studio makes it easy to create engaging, buzz-building screen videos at any size, in any popular format. Download the free trial!
|
|
#1
November 16th, 2003, 02:42 AM
|
|||
|
|||
enormous delete
I executing a batch query to do a delete going on a table which contains over 16 million rows. The delete has been running for more than 24hours and is not finished. If I stop the delete now will it roll everything back? Or will the rows deleted remain deleted?
|
|
#2
November 16th, 2003, 04:39 AM
|
||||
|
||||
|
I don't know if you'll get your data back, but it's possible, it should keep a transaction log.
If you just wanted to empty that table you should have used Truncate or a drop -> create, way much faster. See the docs: Quote:
__________________
My blog about OpenSource Databases PDF tutorials about OSS databases, DBMonster ... Please contribute to Open Source Development, fill bug reports!!! Developer Shed eSupport Commented my.ini/my.cnf (PLEASE ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins Last edited by pabloj : November 16th, 2003 at 04:41 AM.
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > enormous delete |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
