Tag Archives: how delete works in sql server

List 10 difference between TRUNCATE & DELETE statement in SQL Server?

This is a regular interview questions, which is being asked by interviewer for DEV DBA profiles. Here is a extensive list of difference between TUNCATE and DELETE Table statements. TRUNCATE V/s DELETE Truncate Delete TRUNCATE is a DDL command DELETE is a DML command TRUNCATE TABLE always locks the table and page but not each [...]