<t>From Ryan Dunn<br/>
http://dunnry.com/blog/CalculatingTheSizeOfYourSQLAzureDatabase.aspx<br/>
<br/>
`select <br/>
sum(reserved_page_count) * 8.0 / 1024 [SizeInMB]<br/>
from <br/>
sys.dm_db_partition_stats<br/>
<br/>
GO<br/>
<br/>
select <br/>
sys.objects.name, sum(reserved_page_count) * 8.0 / 1024 [SizeInMB]<br/>
from <br/>
sys.dm_db_partition_stats, sys.objects<br/>
where <br/>
sys.dm_db_partition_stats.object_id = sys.objects.object_id<br/>
<br/>
group by sys.objects.name<br/>
order by sum(reserved_page_count) DESC<br/>
<br/>
<br/>
The first one will give you the size of your database in MB and the second one will do the same, but break it out for each object in your database ordered by largest to smallest.</t>
