Recently I have been stumped by not cliaming unused space correctly even though after delete handful of rows on a table. You may be aware using SP_SPACEUSED will get you details such as : Column name Data type Description database_name nvarchar(128) Name of the current database. database_size varchar(18) Size of the current database in megabytes. database_size includes both data and log files. unallocated space varchar(18) Space in the database that has not been reserved for database objects. Column...(
read more)
Read the complete post at http://sqlserver-qa.net/blogs/tools/archive/2007/08/31/failed-to-claim-unused-space-with-sp-spaceused.aspx