T-SQL provides two keywords that allow you to delete data from a table. They are DELETE and TRUNCATE. These are alike in what they are doing, however, they  use vastly different methods. In this article, we discuss underlying mechanisms for these keywords. A difference between TRUNCATE and DELETE TRUNCATE: TRUNCATE is a DDL command. TRUNCATE TABLE always … Continue reading SQL Server: DELETE vs TRUNCATE