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

0 vote199 views1 answer
Sqlite3 now
SQL
0 vote226 views1 answer
Update database collation in postgresql
SQL
0 vote235 views1 answer
Enable outgoing remote MySQL access
SQL
0 vote193 views1 answer
Importerror no module named mysql.connector raspberry pi
SQL
25 votes276 views5 answers
Mysql replace text
SQL
2 votes310 views2 answers
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote247 views1 answer
Prisma transaction
SQL
0 vote254 views1 answer
Sql query inline if
SQL
2 votes236 views1 answer
Sql find not in list
SQL
4 votes174 views3 answers
Create table if not exists postgresql
SQL