Space that a table uses is not completely released after you use a DELETE statement to delete data from the table in SQL Serverly released after you use a DELETE statement to delete data from the table in SQL Server
http://support.microsoft.com/kb/913399/en-us