Peter DeBetta's blog about programming in SQL Server 2008, 2005, etc. using technologies such as T-SQL, .NET, CLR, C#, VB, Visual Studio, and SQL Server Management Studio.
Although not a SQL Server post, I thought this would be helpful for anyone...
In an attempt to clean up my laptop, I have been archiving old projects, setup files, etc., off to a file server. Alas, some directories have a multitude of subdirectories, and trying to figure out how much space each takes up is cumbersome at best. So, I decided to write a quickie utility that will iterate through all files in the directory and subdirectories (or not, if you choose so).
It outputs its results to a multiline text box, so you can easily copy and paste into Excel, sort the results, and see which directories are using all your hard drive space.
The program requires the .NET 2.0 Framework.
And of course, use at your own risk.
Comment Notification
If you would like to receive an email when updates are made to this post, please register here
Subscribe to this post's comments using
About Peter W. DeBetta
Peter DeBetta works for Microsoft as an Application Platform Technology Strategist, specializing in strategies, design, implementation, and deployment of Microsoft SQL Server and .NET solutions. Peter writes courseware, articles, and books – most recently the title Introducing SQL Server 2008 from Microsoft Press. Peter speaks at conferences around the world, including TechEd, SQL PASS Community Summit, DevTeach, SQL Connections, DevWeek, and VSLive!
When Peter isn’t working, you can find him singing and playing guitar (click
here to hear an original song by Peter), taking pictures, or simply enjoying life with his wife, son, and daughter.