Subscribe to:
Post Comments (Atom)
All Database Sizes in SQL SERVER
DB sizes SELECT d.name, (ROUND(SUM(cast(mf.size as bigint)) * 8 / 1024, 0))/1024 Size_GB FROM sys.master_files mf ...
-
We can capture host address of a server through T_SQL using below script. DECLARE @ipaddress varchar ( max ) DECLARE @ipaddressLine...
-
DB sizes SELECT d.name, (ROUND(SUM(cast(mf.size as bigint)) * 8 / 1024, 0))/1024 Size_GB FROM sys.master_files mf ...
No comments:
Post a Comment