Here is a nice link about how to determine space consumed by a SQL Server database for each table by Nigel Rivett:

 

and some other useful scripts: