SELECT fg.groupname AS 'File Group', Name, CONVERT (Decimal(15,2),ROUND(f.Size/128.000,2)) [Currently Allocated Space (MB)], CONVERT (Decimal(15,2), ROUND(FILEPROPERTY(f.Name,'SpaceUsed')/128.000,2)) AS [Space Used (MB)], CONVERT (Decimal(15,2), ROUND((f.Size-FILEPROPERTY(f.Name,'SpaceUsed'))/128.000,2)) AS [Available Space (MB)] FROM dbo.sysfiles f (NOLOCK) JOIN sysfilegroups fg (NOLOCK) ON f.groupid = fg.groupid ORDER BY fg.groupname
About me
Tejas Shah
Microsoft Certified Professional Expert. I have 14+ years of experience in Design and Develop 100+ .Net applications using Asp.Net, C#, Asp.Net Core, VB.Net, SQL Server, MVC, AngularJS, JavaScript, Azure, HTML5 and CSS3.
Categories
Recent Post
-
SQL Server Reporting Services, List out all the data sources with Report Name and Path
Posted by Tejas Shah on November 22, 2017
-
SQL Server, T-SQL create Linked Server with Azure SQL Database
Posted by Tejas Shah on November 11, 2017
-
SQL Server: Use of Recursive Query with example
Posted by Tejas Shah on August 12, 2015
-
SQL Server, avoid encoding special character when using FOR XML PATH
Posted by Tejas Shah on June 26, 2015
-
SQL SERVER: Find Current Location of Log File(s) with File Size of All the Database
Posted by Tejas Shah on April 20, 2015