Originally posted by eschapir
The Truncate is much faster.
The reason – truncate does not record in the transaction log therefore you can not role it back
I am not sure if you guys have experienced this. Truncate command may not work at times. And this is not just happening in my current job but previous job too. When truncate command was used, old records were not removed and when new set of data was loaded, it caused duplicates in the table.
So for peace of mind, I usually placed both truncate and delete commands (though delete will do the job) in some of my missing critical processes.
Sound really silly but it actually happened to me.