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 vote283 views1 answer
Node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
SQL
1 vote268 views1 answer
Mysql get character set
SQL
0 vote336 views1 answer
ALV GRID events
SQL
7 votes284 views4 answers
What is my mysql version
SQL
1 vote270 views1 answer
Show per page table in xampp
SQL
2 votes258 views1 answer
Drop table if exists in postgres
SQL
0 vote233 views2 answers
Https://www.google.com/search?ei=bihqX_v9DJb--gTYoLH4DQ
SQL
0 vote277 views3 answers
Create and attach user to a postgresql database
SQL
1 vote285 views1 answer
Search for replace in mysql
SQL
0 vote291 views1 answer
Allow null in psql
SQL