Skip to content

Instantly share code, notes, and snippets.

@TrevorS

TrevorS/check_free_space.sql

Created March 19, 2015 18:09
Show Gist options
  • Save TrevorS/dbb190c42150aca13172 to your computer and use it in GitHub Desktop.
Save TrevorS/dbb190c42150aca13172 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
check_free_space.sql
SELECT DB_NAME() AS DbName,
name AS FileName,
size/128.0 AS CurrentSizeMB,
size/128.0 - CAST(FILEPROPERTY(name, 'SpaceUsed') AS INT)/128.0 AS FreeSpaceMB
FROM sys.database_files;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment