Discussion in 'SQL Server' started by premchandra, Oct 9, 2013.
Which one is faster DELETE/TRUNCATE?
TRUNCATE is faster, as it does not actually "deletes" the data, but instead, it marks the extents as empty and free for use. On the other hand, DELETE is a "per row" operation, which actually empties the extents' contents, thus performing slower.
Separate names with a comma.