select
    name = object_schema_name(object_id) + '.' + object_name(object_id),

    rows = PARSENAME(cast(convert(varchar, CAST(sum(case when index_id < 2 then row_count else 0 end) AS money), 1) AS varchar), 2),

	reserved_MB = 8 * sum(reserved_page_count) / 1024,
	data_MB = 8 * sum( case when index_id < 2
                        then in_row_data_page_count + lob_used_page_count + row_overflow_used_page_count
                        else lob_used_page_count + row_overflow_used_page_count
                        end ) / 1024,
    index_MB = 8 * (sum(used_page_count) - sum( case when index_id < 2
                                                then in_row_data_page_count + lob_used_page_count + row_overflow_used_page_count
                                                else lob_used_page_count + row_overflow_used_page_count
                                                end )
                    ) / 1024,
	unused_MB = cast(8 * sum(reserved_page_count - used_page_count) / 1024.0 as decimal (18,1))
from sys.dm_db_partition_stats
where object_id > 1024
group by object_id
order by reserved_MB desc