• A good explanation on TRUNCATE vs DELETE can be found at http://www.mssqltips.com/tip.asp?tip=1080.