GilaMonster (6/17/2013)
Jeff Moden (6/17/2013)
then you could use TRUNCATE instead of DELETE and that will be minimally logged.Technically truncate is fully logged. It just logs the page deallocations like a drop table does rather than the rows as delete does.
Agreed. I probably shouldn't have used the words "minimally logged" here but the effect is nearly the same.
--Jeff Moden
Change is inevitable... Change for the better is not.