SQL Server TSQL Delete All Table Rows – TRUCATE TABLE vs DELETE ALL
Use the TRUNCATE TABLE command instead of DELETE ALL FROM [table] if you need to remove all records: The TRUNCATE command will, in most cases,take less time than DELETE especially for large tables. WHY? TRUNCATE doesn’t log each deleted row in the transaction log while DELETE does.