Quick way to find space used by each table in a database
||The article you are reading has moved! It is now available at: http://blog.tinisles.com/2006/01/quick-way-to-find-space-used-by-each-table-in-a-database/|
Found this very handy:
sp_msforeachtable 'sp_spaceused "?"'
Produces a kind of ugly output (returns a table for each table). The original article includes a query to get all the results into one table: Quick way to find space used by each table in a database