April 8, 2010 at 11:59 am
Lynn Pettis (4/7/2010)Not completely true
Not completely exact.
As you know during a truncate operation SQL Server logs page deallocation information - that's why you can roll it back. This is not the same log effort a mass delete operation requires.
Note that the minimal log required by truncate is independent of the size of the table while the full log required by delete is dependent of the number of rows deleted. That's why - in practical terms I say delete is a logged operation while truncate it isn't.
Appologies for the confusion 😉
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.Viewing post 16 (of 15 total)
You must be logged in to reply to this topic. Login to reply