Use the TRUNCATE TABLE command instead of DELETE ALL FROM [table] if you need to remove all records:
TRUNCATE TABLE Employee; /* instead of */ DELETE ALL FROM Employee;
The TRUNCATE command will, in most cases,take less time than DELETE especially for large tables.
TRUNCATE doesn’t log each deleted row in the transaction log while DELETE does.
A 30+ year database veteran. I enjoy sharing my stories and knowledge with others.