reclaim unsued space in sql 2008

Posted by opensas on Stack Overflow See other posts from Stack Overflow or by opensas
Published on 2011-02-15T23:20:23Z Indexed on 2011/02/15 23:25 UTC
Read the original article Hit count: 221

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?

© Stack Overflow or respective owner

Related posts about sql-server-2008

Related posts about administration