>Sergey, follow up question: I now know how much space is reserved, used, and unused (thanks!). I show one table that I recently deleted bunch of records and it shows that the table is using just a small portion of the space that is reserved for it. How do I reclaim this unused space taken up by the table? Thanks again.
The DBCC DBREINDEX should do that if table has clustered index.
--sb--