Determine Space Used By a SQL Server Database with sp_SpaceUsed

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: