What is the different between delete and truncate?
Most of the interviewer will be satisfied with this answer.
TRUNCATE is a DDL command and DELETE is a DML command
Delete performs row by row, where as TRUNCATE performs at page level
If the interviewer needs more elaborative answer(Not frequently)
SQL Server Interview Questions · · · ·