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 vote324 views1 answer
Sqlite referential integrity
SQL
18 votes344 views6 answers
Laravel form validation
SQL
1 vote356 views2 answers
Postgresql truncate cascade restart identity
SQL
0 vote375 views1 answer
Transaction and commit trong sql server
SQL
0 vote384 views1 answer
Oracle sql developer closed connection
SQL
0 vote360 views1 answer
Get last three characters in mysql column
SQL
1 vote330 views1 answer
Function difference_in_hours(timestamp with time zone) does not exist
SQL
1 vote346 views1 answer
Sql select all from one table and one column from another
SQL
10 votes375 views2 answers
Mysql remove only_full_group_by permanently
SQL
3 votes356 views3 answers
Restart mysql mac
SQL