Azure SQL database size query

azure-db-size.sql

GO

select sum(reserved_page_count) * 8.0 / 1024 AS DbSizeInMB
from sys.dm_db_partition_stats 

GO

select sys.objects.name as 'TableName', sum(reserved_page_count) * 8.0 / 1024 as 'Size (in MB)'
from sys.dm_db_partition_stats, sys.objects 
where sys.dm_db_partition_stats.object_id = sys.objects.object_id
group by sys.objects.name
order by 'Size (in MB)' desc


GO

SELECT o.name AS ObjectName,
   i.name AS IndexName,
   ddips.avg_fragmentation_in_percent,
   ddips.page_count,
   ddips.compressed_page_count,
   ddips.index_depth,
   ddips.record_count
FROM sys.dm_db_index_physical_stats(DB_ID('{{DB-NAME}}'),

OBJECT_ID('{{DB-NAME}}'), DEFAULT,
   DEFAULT, 
'DETAILED') AS ddips
   JOIN sys.objects AS o   
   ON ddips.object_id = o.object_id
   JOIN sys.indexes AS i
   ON ddips.index_id = i.index_id
      AND ddips.object_id = i.object_id;