Time and Space: How to Monitor Drive Space in SQL Server
How to monitor drive space in T-SQL and calculate when your drives will run out of space.
2016-01-19
7,913 reads
Drive space
Get file sizes of database files and free space on disk
Reports on the data and log file sizes and space used within files for each database on a servers. It also includes the free space on the drive where the file is located.
2016-03-10 (first published: 2015-07-23)
3,905 reads
Blogs
Server Review Essentials for Accidental and Junior DBAs—Setting Up (Part 1)
By Kevin3NF
Welcome to a new year, and a new look at what I’ve learned in...
Azure SQL vCore vs DTU
By Arun Sirpal
If you are building database solutions in Azure , using Azure SQL Database then...
Synapse Analytics Spark Example 2 - ROW_NUMBER()
By Ed Elliott
The next example is how to do a ROW_NUMBER(), my favourite window function. T-SQL SELECT...
Forums
Deadlock - What to do next?
Hi, I have a job that keeps getting a deadlock victim error and fails....
XML Vs Non-XML
I am using SQL Server 2008 R2. While using XML data type and XQuery...
Staging or UAT Environment
Hi Experts, Currently, we are using the enterprise edition of SQL Server 2014 in...
Ask SSC