Home Forums SQL Server 2005 Administering Too big amount of unused space after shrink of image field contents RE: Too big amount of unused space after shrink of image field contents

  • If the table is clustered (has a non-clustered index, then you can try a DBCC DBREINDEX (tablename,'',100). The '' specifies to reindex all indexes on the table, and the 100 specifies to completely fill the data pages when done.

    If not, then create a clustered index on any column, specify a fill factor of 100. After creation you can drop the index.

    Unfortunately, this process could take a while on a 100GB table.