mikeg13 (1/17/2014)
As mentioned here there are indexes shown in the results. Would it make sense if I were to group by the "Name" and do a SUM(reserved_page_count * 8) as space_used_kb to get the total space used for the table (including indexes), and do a MAX(row_count) as row_count to get the number of records?
Yes, I can see the value of having sum. I had made another script and posted on my blog, check it out if you're interested. Thank you for your suggestion.