Skip to content

Instantly share code, notes, and snippets.

@sunmeat

sunmeat/24.11

Forked from FromMeloriWithLove/24.11
Created December 22, 2023 11:07
Show Gist options
  • Save sunmeat/e8dd95b203faacdf7ccdeccf5e2d7486 to your computer and use it in GitHub Desktop.
Save sunmeat/e8dd95b203faacdf7ccdeccf5e2d7486 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
24.11
SELECT
DB_NAME(database_id) AS DatabaseName,
SUM(size) * 8 AS SizeInBytes
FROM
sys.master_files
WHERE
database_id > 4
GROUP BY
database_id
ORDER BY
DatabaseName;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment