Tag: TRUNCATE

By Posted on Posted in Recovery No Comments Tagged with , , ,

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 Bobby Tables. He is the SQL injection guy who’s parents named him. Robert’); DROP TABLE Students; — And what that name does, is it SQL injection that basically closes out the current SQL statement, then …

Recovering from a dropped or truncated table Read more »

By Posted on Posted in Corruption, Performance Tuning No Comments Tagged with , ,

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, …

Difference Between TRUNCATE TABLE and DELETE FROM Table Read more »