sp_spaceused provides a summary of space use:
In the database
By a table and its indexes and text/image storage
By a table, with separate information on indexes and text/image storage
