Thursday, June 03, 2010

sql server database size report

SELECT * INTO #T1 FROM sys.sysfiles;
DELETE FROM #T1;
EXECUTE sp_msforeachdb 'INSERT INTO #T1 SELECT * from ?.sys.sysfiles'

select ( size * 0.00000762939453125 )as SizeGB , * from #t1
order by size desc

11 Comments:

At 10:40 PM, Anonymous RS Gold said...

This is a great article, supplies the useful information for me.

 
At 12:29 AM, Anonymous gold wow said...

Your blog provided us with valuable information to work with . Each & every tips of your post are awesome. Thanks a lot for sharing. Keep blogging.

 
At 3:33 AM, Anonymous wedding dresses 2012 said...

Lace, lace, lace…Call me Grace. A figuration of delicacy and intricacy, lace wedding dresses casts her spell on every female beating-heart, with the treatment ranging from tucked decoration details to an avalanche of lace appliqué throughout the torso. Our simple wedding dresses collection normally features with pearls, beading, sequins and embroidery, and subsequently blooms into an astounding Mermaid silhouette.

 
At 4:39 AM, Blogger ambersbridal said...

A holy church, rings, a bouquet, a 3-floor wedding cake, lace wedding dress
champagne, and the moving promise “ I do”, make up the happiest moment in one’s life. Then it is the wedding.
lace wedding gowns
A gorgeous wedding dress has been inside a girl’s dream since she was five years old. It is widely said that the bride is the most beautiful woman all over the world.
Bridal gowns vary in different parts of the world. For example, cheap wedding dresses plus sizein traditional Chinese culture, the color red is regarded for centuries as the symbol of good luck; while in the Occident, wedding dresses 2012 a full-length white wedding dress is always associated with romance and sanctity. But, with the globalization, wedding dresses tend to be alike in the whole world.

 
At 3:57 AM, Blogger teracheapgold said...

This is a very interesting blog and so i like Cheap WOW Gold Eu and visit your blog again and again. Keep it up.Enjoy when you can, and endure when you must. it ls a good article and love your words , so charming and make people learn a lot Cheap WOW Gold, thanks !come to my site to Buy WOW Gold EU for more cool games gold.

 
At 8:22 PM, Blogger hermesonlinestore said...

I support your idea very much and here is a good choice for you no matter what mood you are: just remember to pay attention to the fashion trend of Hermes Kelly Birkin such as New Hermes or the other styles like Kelly Hermes Bag. I promise you will relax yourself. So come on, know more fashion style arround you and make yourself more confidence.

 
At 8:22 PM, Blogger hermesonlinestore said...

I support your idea very much and here is a good choice for you no matter what mood you are: just remember to pay attention to the fashion trend of Hermes Kelly Birkin such as New Hermes or the other styles like Kelly Hermes Bag. I promise you will relax yourself. So come on, know more fashion style arround you and make yourself more confidence.

 
At 8:23 PM, Blogger hermesonlinestore said...

I support your idea very much and here is a good choice for you no matter what mood you are: just remember to pay attention to the fashion trend of Hermes Kelly Birkin such as New Hermes or the other styles like Kelly Hermes Bag. I promise you will relax yourself. So come on, know more fashion style arround you and make yourself more confidence.

 
At 12:20 AM, Anonymous Anonymous said...

They are all beautiful and fashionable i have to say, and my friends told me they are of good quality as well. I have not see post good enough like yours here.
More tags:
cheap wow gold | buy wow gold | wow gold for sale | runescape gold | runescape gold for sale

 
At 11:47 PM, Anonymous china tours said...

That is really cool. Thanks for finding it. Some really good ideas there, this is going to be a real time sink. I am a china tour lover,You can learn more: China tourism | China travel service | China vacation packages

 
At 3:11 PM, Anonymous Anonymous said...

Blogs essaymarket.co.uk are so interactive where we get lots of informative on any topics...... nice job keep it up !!

 

Post a Comment

<< Home