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 vote293 views1 answer
Setting default value for Boolean data type in SQL
SQL
1 vote299 views1 answer
Mysql breakline on string
SQL
1 vote184 views1 answer
Complete output (15 lines): /bin/sh: 1: mysql_config: not found /bin/sh: 1: mariadb_config: not found /bin/sh: 1: mysql_config: not found Traceback (most recent call last): File "<string>", line 1, in <module> File "/tmp/pi
SQL
0 vote183 views1 answer
Change date format in oracle query
SQL
0 vote176 views3 answers
Get free card roblox
SQL
0 vote193 views1 answer
Query params sql insert python f string
SQL
16 votes182 views4 answers
Ascending order mysql
SQL
1 vote170 views1 answer
Substr sql last character
SQL
0 vote180 views1 answer
Get clob size oracle
SQL
1 vote164 views1 answer
Delete triger pl pg sql
SQL