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.

>>Is there a way to view size of each table in a database? Size in MB would be ideal but I don't know how MSSQL stores records in the database so...
>>
>>I want to see which tables are taking up a lot of physical space in a database. TIA.
>
>

USE pubs
>EXEC sp_spaceused 'titles'
>

Take a look also at http://www.sqlteam.com/item.asp?ItemID=282