Geeks With Blogs

News kaleidoscope 1817, lit. "observer of beautiful forms," coined by its inventor, Sir David Brewster (1781-1868), from Gk. kalos "beautiful" + eidos "shape" (see -oid) + -scope, on model of telescope, etc. Figurative meaning "constantly changing pattern" is first attested 1819 in Lord Byron, whose publisher had sent him one.
Kaleidoscope Everything under the sun, ending in .Net

A neat trick on how to measure your database size in SQL Azure.  Here are the exact queries you can run to do it:

Select
Sum (reserved_page_count) * 8.0 / 1024
From
sys.dm_db_partition_stats
GO

Select
sys.objects.name, sum (reserved_page_count) * 8.0 / 1024
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

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.

http://www.azurejournal.com/2010/03/sql-azure-database-size-calculator/

 

Ritesh

Technorati Tags:
Posted on Sunday, March 21, 2010 5:45 PM | Back to top


Comments on this post: SQL Azure Database Size Calculator

No comments posted yet.
Your comment:
 (will show your gravatar)


Copyright © kaleidoscope | Powered by: GeeksWithBlogs.net