SQL Myth: Truncate Cannot Be Rolled Back Because It Is Not Logged

(Denis Gobo) I am still amazed at how many people still think that TRUNCATE TABLE is not logged. There is some logging going on but it is minimal, here is what Books On Line says: TRUNCATE TABLE removes the data by deallocating the data pages used to store the table’s data, and only the page dea

Read More - Register for Free Membership