SQL Server 2012+ Database size list

SELECT      sys.databases.name, 
            CONVERT(VARCHAR,SUM(size)*8/1024)+' MB' AS [Total disk space] 
FROM        sys.databases 
JOIN        sys.master_files 
ON          sys.databases.database_id=sys.master_files.database_id 
GROUP BY    sys.databases.name 
ORDER BY    sys.databases.name

Comments

Post a Comment

Popular posts from this blog

c# Json Pretiffy

public   static   string  JsonPrettify( string  json) {      using  ( var  stringReader =  new   StringReader (json))      using  ( var  stringWriter =  new   StringWriter ())     {          var  jsonReader =  new   JsonTextReader (stringReader);          var  jsonWriter =  new   JsonTextWriter (stringWriter) { Formatting =  Formatting .Indented };         jsonWriter.WriteToken(jsonReader);          return  stringWriter.ToString();     } }
Read more

List of column in SQL Server Tables

SELECT   SchemaName = c.table_schema,          TableName = c.table_name,          ColumnName = c.column_name,          DataType = data_type FROM     information_schema.columns c          INNER JOIN information_schema.tables t            ON c.table_name = t.table_name               AND c.table_schema = t.table_schema               AND t.table_type = 'BASE TABLE' ORDER BY SchemaName,          TableName,          ordinal_position
Read more