06-19-07, 05:43 #1Registered User
- Join Date
- Jun 2004
Unanswered: Percentage free space in datafiles
I want to calculate the percentage of free space in my datafiles.
But the problem is, how?!
I know how to calculate the size and maxsize from the sysfiles, therefore I used these queries.
select sum(maxsize) from dbo.sysfiles
select sum(size) from dbo.sysfiles
Can anybody help me out??