Purpose:To reduce the size of the transaction log file when it becomes excessively large.To free up disk space.To improve performance by reducing the time it takes to backup the transaction log
TRUNCATE and DELETE are both SQL statements used to remove data from a table. However, they serve slightly different purposes and have distinct implications: