Note: Technical Talk being moved to:
www.nazimcricket.com/wiki


Monday, 28 June 2010

Truncate and Shrink Database

On SQLServer I've learnt that we can't take for granted that a table truncate will reuse storage. Therefore to reclaim empty space following the truncate of a large table, I ran:
DBCC SHRINKDATABASE (DBNAME, TRUNCATEONLY)
GO

No comments: