Mssql show database size

Get all db sizes in mysql server

SELECT table_schema "DB Name",
        ROUND(SUM(data_length + index_length) / 1024 / 1024, 1) "DB Size in MB" 
FROM information_schema.tables 
GROUP BY table_schema;

Source: stackoverflow.com

Mssql show database size

SELECT 
      database_name = DB_NAME(database_id)
    , log_size_mb = CAST(SUM(CASE WHEN type_desc = 'LOG' THEN size END) * 8. / 1024 AS DECIMAL(8,2))
    , row_size_mb = CAST(SUM(CASE WHEN type_desc = 'ROWS' THEN size END) * 8. / 1024 AS DECIMAL(8,2))
    , total_size_mb = CAST(SUM(size) * 8. / 1024 AS DECIMAL(8,2))
FROM sys.master_files WITH(NOWAIT)
WHERE database_id = DB_ID() -- for current db 
GROUP BY database_id

Source: stackoverflow.com

Similar codes

1 vote103 views1 answer
Drop table if exists oracle
SQL
0 vote105 views1 answer
Insufficient memory to excute the sql query
SQL
0 vote115 views2 answers
T sql null or empty string
SQL
0 vote114 views1 answer
Simple plsql program run in oracle sql developer but got the error
SQL
7 votes107 views6 answers
Nth highest salary in sql
SQL
6 votes103 views1 answer
Phpmyadmin password root
SQL
0 vote132 views1 answer
This week mysql
SQL
1 vote102 views1 answer
Adding a default constraint to an existing column in sql
SQL
0 vote111 views1 answer
Mysql, how to query the table comments?
SQL
0 vote113 views1 answer
Failed to process SQL command - ORA-28014: cannot drop administrative user or role
SQL