T-SQL Snack: How Much Free Storage Space is Available?

Posted by andyleonard on SQL Blog See other posts from SQL Blog or by andyleonard
Published on Thu, 27 May 2010 11:00:00 GMT Indexed on 2010/05/27 11:12 UTC
Read the original article Hit count: 208

Filed under:

Database Developer

|

T-SQL Snack

Introduction Ever have a need to calculate the total available storage space for a server? Recently I did. Here's a solution I came up with - I bet someone can do this better! xp_fixeddrives There's a handy stored procedure called xp_fixeddrives that reports the available storage space: exec xp_fixeddrives This returns: drive MB free ----- ----------- C 6998 E 201066 Problem solved right? Maybe. The Sum What I really want is the sum total of all available space presented to the server. I built this...(read more)

© SQL Blog or respective owner

Related posts about Database Developer

Developer Developer Developer Scotland 2010

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
This past weekend, I headed up to Glasgow thanks to Plip for driving and Dave Sussman for some light entertainment to do a session on C# on the iPhone with MonoTouch. I had already presented a session similar to this one at DDD8 in Reading, which you can watch on Vimeo ( http://vimeo.com/9150434 )… >>> More
Setting int more than once causes crash

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm doing a CABasicAnimation and getting the value from a nested NSMutableArray. Everything is great the first time it runs but crashes when called again either with custom functions or viewDidLoad. I've isolated it down to this line int int1 = [[[locationsArray objectAtIndex:0] objectAtIndex:0… >>> More
SQL SERVER Retrieve and Explore Database Backup without Restoring Database Idera virtual database

as seen on Dot net Slackers - Search for 'Dot net Slackers'
I recently downloaded Ideras SQL virtual database, and tested it. There are a few things about this tool which caught my attention.My ScenarioIt is quite common in real life that sometimes observing or retrieving older data is necessary; however, it had changed as time passed by. The full database… >>> More
More than 100,000 articles !

as seen on Developer IT - Search for 'Developer IT'
In one month, we already got more than 100,000, and we continue to crawl! We plan on hitting 250,000 total articles next month. Due to the large amount of data we are gathering, we are planning on updating our SQL stored procedure to improve performance. We may be migrating to SQL Server 2008 Entreprise… >>> More
Official BETA release of Developer IT

as seen on Developer IT - Search for 'Developer IT'
We finally did it It’s been a week since our first online publish and our indexer robot is going as well as the website. We already have reach more than 20,000 articles and it’s only the begining. Stay tune on http://www.developerit.com/ >>> More

Related posts about T-SQL Snack

SQL SERVER – Concat Strings in SQL Server using T-SQL – SQL in Sixty Seconds #035 – Video

as seen on SQL Authority - Search for 'SQL Authority'
Concatenating string is one of the most common tasks in SQL Server and every developer has to come across it. We have to concat the string when we have to see the display full name of the person by first name and last name. In this video we will see various methods to concatenate the strings. SQL… >>> More
Writing A Transact SQL (TSQL) Procedure For SQL Server 2008 To Delete Rows From Table Safely

as seen on Dot net Slackers - Search for 'Dot net Slackers'
In this post, we will show and explain a small TSQL Sql Server 2008 procedure that deletes all rows in a table that are older than some specified date. That is, say the table has 10,000,000 rows in it the accumulated over the past 2 years. Say you want to delete all but [...]...Did you know that… >>> More
difference between tsql, access sql and pl/sql

as seen on Stack Overflow - Search for 'Stack Overflow'
i am very confused please help to clarify these differences! are they all completely different languages? what is the overlap? >>> More
SQLAuthority News – Microsoft SQL Server Protocol Documentation Download

as seen on SQL Authority - Search for 'SQL Authority'
The Microsoft SQL Server protocol documentation provides detailed technical specifications for Microsoft proprietary protocols (including extensions to industry-standard or other published protocols) that are implemented and used in Microsoft SQL Server to interoperate or communicate with Microsoft… >>> More
SQL SERVER – Interview Questions & Answers Needs Your Help

as seen on SQL Authority - Search for 'SQL Authority'
About an year ago, I had posted SQL Server related Interview Questions and Answers. It was very well received in community. I have received many comments, suggestions and emails on this subject. I am planning to upgrade the Interview Questions and Answers and take it to next level. Here, I need your… >>> More