select o.name,        SUM(p.reserved_page_count) as reserved_page_count,        SUM(p.used_page_count) as used_page_count,        SUM(        case        when(p.index_id<2) then (p.in_row_data_page_count+        p.lob_used_page_count+p.row_overflow_used_page_count)        else p.lob_used_page_count+p.row_overflow_used_page_count        end        ) as DataPages,        SUM(        case        when (p.index_id<2) then row_count        else 0        end        ) as rowCounts        from sys.dm_db_partition_stats p inner join sys.objects o        on p.object_id=o.object_id        group by o.name        order by rowCounts desc