Calculating Available Disk Size in SQL Server
Hello everyone, In this article, I will try to give information about calculating the available disk size in SQL Server. You can easily do this using the code below. SELECT Drive, TotalSpaceGB, FreeSpaceGB, PctFree FROM ( SELECT DISTINCT SUBSTRING(dovs.volume_mount_point, 1, 10) AS Drive, CONVERT(INT, dovs.total_bytes / 1024.0 / 1024.0 /...