• Good question; there are a number of links you could have included in the explanation, but one of my favourites is this by Kalen Delaney:

    http://sqlblog.com/blogs/kalen_delaney/archive/2010/10/12/tsql-tuesday-11-rolling-back-truncate-table.aspx