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. Rob MillsA 30+ year database veteran. I enjoy […]

SQL Server TSQL Delete All Table Rows – TRUCATE TABLE vs DELETE ALL Read More ยป