SQL Server - Get total size of all DBs

MS SQL Server

Published Apr 21, 2015 |
Scroll

MS SQL Server

Get total size of all databases on an instance:

SELECT CONVERT(DECIMAL(10,2),(SUM(size * 8.00) / 1024.00 / 1024.00)) As UsedSpace
FROM master.sys.master_files
Next up

Cisco Cheatsheet

Useful things to know for managing Cisco devices

Published Feb 12, 2015 |