C# / .NET Tips
Friday, August 10, 2012
database file usage
SELECT
name
,
size
/
128.0
-
CAST
(
FILEPROPERTY
(
name
,
'SpaceUsed'
)
AS
int
)/
128.0
AS
AvailableSpaceInMB
FROM
sys
.
database_files
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)
