reclaim unsued space in sql 2008
- by opensas
I have a table with more than 300.000 records, that weights approximately 1.5 GB
In that table I have three varchar(5000) fields, the rest are small fields
I issue an update, setting those three fields to ''
An after a shrink (database and files) the database uses almost the same space as before...
DBCC SHRINKDATABASE(N'DataBase' )
DBCC SHRINKFILE (N'DataBase' , 1757)
DBCC SHRINKFILE (N'DataBase_log' , 344)
any idea?