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: