DBA Myths: TRUNCATE TABLE deletes all the rows of a table instantly. This is an off-site link.  Please review our Terms of Service for additional information.

(Kenneth Fisher) Most DBAs and developers I’ve talked to over the years have felt that TRUNCATE TABLE is an instant DELETE. However would you believe that it doesn’t actually delete the data from the pages at all?

Read this article...

comments powered by Disqus