Example SQL Server FreeSpace in Datafiles

Description:
Example to show the FreeSpace in Datafiles for selected database,
Check the example below:

------------------------------------------------------------------------------------------------------

SELECT Name
,      FileID
,      Filename
,      CONVERT(Decimal(15,2),ROUND(a.Size/128.000,2)) [Currently Allocated Space (MB)]
,      CONVERT(Decimal(15,2),ROUND(FILEPROPERTY(a.Name,'SpaceUsed')/128.000,2)) AS [Space Used (MB)]
,      CONVERT(Decimal(15,2),ROUND((a.Size-FILEPROPERTY(a.Name,'SpaceUsed'))/128.000,2)) AS [Available Space (MB)]
FROM dbo.sysfiles a (NOLOCK);