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

5 votes289 views1 answer
FSADeprecationWarning: SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and will be disabled by default in the future. Set it to True or False to suppress this warning.
SQL
7 votes222 views1 answer
Return insert results in POSTGRESQL
SQL
0 vote236 views1 answer
Mysql wait_timeout
SQL
7 votes209 views2 answers
Add column table pl sql
SQL
0 vote197 views1 answer
Mysql query to check record exists in database table or not
SQL
0 vote218 views1 answer
Oracle list subpartitions
SQL
0 vote208 views1 answer
Print boolean in plsql
SQL
1 vote210 views1 answer
Table valued functions in sql
SQL
0 vote281 views1 answer
How to add auto increment primary key
SQL
1 vote194 views1 answer
How to delete data from sql database in android
SQL