title: reclaim unused space in SQL Server 2008
body: <p>I have a table with more than 300,000 records, of size approximately 1.5 GB</p>
  
  <p>In that table I have three <code>varchar(5000)</code> fields, the rest are small fields.</p>
  
  <p>In issuing an <code>update</code>, setting those three fields to <code>''</code>.</p>
  
  <p>After a shrink (database and files) the database uses almost the same space as before...</p>
  
  <pre><code>DBCC SHRINKDATABASE(N'DataBase' )
  DBCC SHRINKFILE (N'DataBase' , 1757)
  DBCC SHRINKFILE (N'DataBase_log' , 344)
  </code></pre>
  
  <p>Any ideas on how to reclaim that disk space?</p>