Finding the Table Size

Try this:

SELECT object_name(object_id) as objectname, SUM(used_page_count) * 8192. / 1024 / 1024 as pages_used_MB
FROM sys.dm_db_partition_stats
GROUP BY object_id
ORDER BY SUM(used_page_count) DESC;

I use this script : Monitoring Table Growth with PowerShell In fact it shows you the rate of growth existing in each table, at each database of each server. But in the TOTAL column you have the size of it with the sum of IndexSpaceUsed + DataSpaceUsed for each table

Actually for what you said, Rob has put the best way. I voted for him .. But If you want an automated routine and that will show you beyond the size, growth rate of each table..there is..and works fine...