Advertisements
Monthly Archives: October 2012
Don’t believe everything you read: Truncate table is not logged
Actually I’m not sure if anyone still believes this anymore. If you read the BOL description carefully it states that truncate de-allocates the pages rather than deleting the rows – meaning only the de-allocations are logged – resulting in far … Continue reading
Posted in Database Theory, SQL Server, T-SQL
1 Comment