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

10 votes386 views6 answers
Mysql set root password
SQL
7 votes311 views1 answer
Append column sql
SQL
1 vote323 views1 answer
Calculate age in sql postgresql
SQL
0 vote359 views1 answer
Update top 100 order by sql server
SQL
0 vote367 views1 answer
Oracle pl/sql check if file exists
SQL
16 votes402 views2 answers
Sql vs nosql
SQL
5 votes314 views1 answer
Oracle get nls settings
SQL
0 vote335 views1 answer
Postgresql select join by date - Join rows where a timestamp value is equal to midnight of the date
SQL
2 votes362 views2 answers
Mysql on duplicate key update get value from values
SQL
0 vote355 views2 answers
Generate sql trigger through ef migration
SQL