SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag Truncate Rss

Search for any content tagged truncate

   Items 1 to 4 of 4   
 

Performance Myths : Truncate Can't Be Rolled Back

Derik Hammer sets out to disprove another pervasive performance myth : TRUNCATE is faster than DELETE because it isn't logged and can't be rolled back.  Read more...
By Additional Articles 2017/06/01 | Source: SQLPerformance.com | Category: performance
Rating:  Rate this |   Briefcase | 4,354 reads

Differences between Delete and Truncate in SQL Server

Atul Gaikwad details the differences between DELETE and TRUNCATE, including how they vary in terms of being rolled back.   Read more...
By Additional Articles 2016/05/18 | Source: MSSQLTips.com | Category: delete
Rating: (not yet rated)  Rate this |   Briefcase | 4,318 reads

Who Truncated That Table and What Do I Do Now?

This article describes a way to identify the user who truncated the table & how you can recover the data.  Read more...
By Sujeet Singh 2015/02/20 (first published: 2014/06/05) | Source: SQLServerCentral.com | Category: truncate
Rating: |  Discuss |   Briefcase | 25,440 reads

Who Truncated That Table and What Do I Do Now?

This article describes a way to identify the user who truncated the table & how you can recover the data.  Read more...
By Sujeet Singh 2015/02/20 (first published: 2014/06/05) | Source: SQLServerCentral.com | Category: truncate
Rating: |  Discuss |   Briefcase | 25,440 reads
   Items 1 to 4 of 4