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:

Sum (reserved_page_count) * 8.0 / 1024

Select, sum (reserved_page_count) * 8.0 / 1024
sys.dm_db_partition_stats, sys.objects
sys.dm_db_partition_stats.object_id = sys.objects.object_id
Group by

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.



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: