Recovering from a dropped or truncated table
All right, so how about someone dropped or truncated a table? What are you going to do? There’s the joke about a child named little… Read More »Recovering from a dropped or truncated table
TRUNCATE
Difference Between TRUNCATE TABLE and DELETE FROM Table
Most DBAs know the usual difference between TRUNCATE and DELETE FROM, however one not so obvious difference between the two is how things are handled if the table is corrupt.
For instance, if you look at the corrupt database from the Database Corruption Challenge Week 1, you see the following
If you want to clear out the corrupt Revenue table, one way to attempt to do it is with a DELETE statement like this.
Read More »Difference Between TRUNCATE TABLE and DELETE FROM Table