Delete vs Truncate

Delete It is a DML command We can use filters in WHERE clause to delete the data Removes specified data only Deletes one row at a time Records removed data in transaction logs It does not resets the identity field of the

Read More

Why Truncate is faster than Delete?

When we are Deleting the records from a table, it does the following. Read the required records based on Where condition Deletes each record one by one and also updates the transaction log Update Indexes Check for Constraints on the table Check

Read More

What is the basic difference between DELETE and TRUNCATE commands?

DELETE It is a DML command We can use filters in WHERE clause to delete the data Removes specified data only Deletes one row at a time Records removed data in transaction logs It does not resets the identity field of the

Read More