I am deleting 257 million rows out of a table in SQL Server 2008. I can’t truncate it. I probably could have done it smarter though.
2 hours into the delete, the log file grew and I am out of disk space. The query is still running.
What should I do? Will the delete succeed?
Wait for the tx to roll back, the delete will not succeed. Or load a backup – could be faster.
Either delete in increments (10.000 at a time) or make sure your server is adequate to handle your needs. All that CAN be done there.
Leave a comment
- What is the easiest way to upgrade my existing Perl 5.14 to Perl 5.16 on FreeBSD 9 using the ports system?
- Know if mysql has done its job
- Redirect https .com to https .co.uk without a valid SSL cert on .com without DNS change
- Why is it a bad idea to use customer email as from address
- 100% packets dropped on first RX queue on 3/5 raid6 iSCSI NAS devices using intel igb (resolved)