SQL database and tables sizes

DatabaseSize.sql

-- Database size in MB
SELECT
  SUM(reserved_page_count) * 8.0 / 1024 AS 'MB'
FROM sys.dm_db_partition_stats

-- https://ignas.me/tech/sql-database-tables-sizes/

DatabaseTableSizes.sql

-- Database table sizes in MB 
SELECT
  sys.objects.name,
  SUM(reserved_page_count) * 8.0 / 1024 AS 'MB'
FROM sys.dm_db_partition_stats,
     sys.objects
WHERE sys.dm_db_partition_stats.object_id = sys.objects.object_id
-- Line below limits query to return user created tables only
AND sys.objects.type_desc = 'USER_TABLE'
GROUP BY sys.objects.name
ORDER BY MB DESC

-- https://ignas.me/tech/sql-database-tables-sizes/