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
8,220 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)
4,141 reads
Blogs
Learn some critical SQL Security with the MidnightDBAs (Thursday, Jan 20)
By Jen McCown
Friends, the MidnightDBAs have a plan for 2022. A capital-P Plan. And it involves...
CosmosDB and Consistency
By Steve Jones
I was doing a little work with CosmosDB recently, and there were a few...
Daily Coping 17 Jan 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Linked Server UPDATE & DELETE fails . But INSERT & SELECTs work fine
Hello, I have a Windows 2019 machine. I have SQL Server 2016 and the...
Extended Events - how can I query the location of File Target of an XE Session?
If I know the XE Session name, is there a query to find out...
tricky query with patterns of consecutive rows
Hi! I'm having struggle with selecting rows, that match "dynamic" rules as described: if...
Ask SSC