Andy Leonard is CSO of Linchpin People and SQLPeople, an SSIS Trainer, Consultant, and developer; SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is a co-author of SQL Server 2012 Integration Services Design Patterns. His background includes web application architecture and development, VB, and ASP. Andy loves the SQL Server Community!

Browse by Tags

All Tags » Database Develo... » T-SQL Snack   (RSS)

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

  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 Read More... Posted Thursday, May 27, 2010 8:00 AM by andyleonard | 6 Comments Filed under: Database Developer, T-SQL Snack