Query Tables Size

From http://goo.gl/dF6Cv
and http://goo.gl/jxTTa

CREATE TABLE #TempTable
(
    tableName varchar(100),
    numberofRows varchar(100),
    reservedSize varchar(50),
    dataSize varchar(50),
    indexSize varchar(50),
    unusedSize varchar(50)
)

INSERT INTO #TempTable
EXEC sp_MSforeachtable @command1="EXEC sp_spaceused '?'"

SELECT *, cast(cast(replace(reservedSize, ' KB', '') as int)/1024 as varchar) + ' MB' AS Size 
FROM  #TempTable 
ORDER BY cast(replace(reservedSize, ' KB', '') as int) DESC

Result: