Is there is a way to find out the size of a table i.e know which is the biggest table in the database apart from doing a row count and deducing the size ?
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...
No one has followed this question yet.