Sql server query to find all tables and space they used

This query is used to find all tables and space they used

SELECT sum ( used_page_count ) * 8 as SizeKB,

  sum(row_count) as [RowCount], object_name ( object_id ) AS TableName

FROM sys.dm_db_partition_stats

WHERE index_id=0 or index_id=1

GROUP BY object_id

ORDER BY sum ( used_page_count ) DESC