Home > Microsoft, MSBI, SQL, SQL Server > SQL Delete Truncate Drop

SQL Delete Truncate Drop


  1. August 9, 2013 at 5:06 pm

    As you probably realize, there is a fundamental difference between truncate and drop. Truncate does not delete rows on the object in question, it deletes pages which is why you cannot use a where clause to determine what is deleted. Truncate does delete rows, but only from system objects that are referencing the pages that are being removed. Truncate is also a minimally logged operation whereas delete is a fully logged operation. There is far less logged when pages are dropped and system objects are updated then doing a large delete. The speed in which these statements perform is based on the count of pages/rows. But yes, truncate is definitely faster… Hope it helps…

    • Share your knowledge
      August 9, 2013 at 5:20 pm

      Thanks for your more insides on truncate and delete.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: