Ms sql database data size

SELECT DB_NAME(database_id) AS DatabaseName,
       Name AS Logical_Name,
       Physical_Name,
       (size * 8) / 1024 SizeMB
FROM sys.master_files
WHERE DB_NAME(database_id) = 'MY_DB'

Source: stackoverflow.com

Similar codes

8 votes194 views6 answers
Sql insert
SQL
2 votes170 views1 answer
How to make insert script from table in SQL server
SQL
0 vote179 views1 answer
Sql developer search all packages for text
SQL
0 vote188 views1 answer
Mysql best varchar length size
SQL
1 vote203 views1 answer
Sql random sampling per group
SQL
0 vote171 views1 answer
Database get 10 user aleatory
SQL
0 vote125 views1 answer
Java spring boot connect to sql server
SQL
0 vote189 views1 answer
Uncheck constraints and delete from table
SQL
0 vote300 views1 answer
Dublicate row sql
SQL
5 votes164 views1 answer
How to check nls timestamp format in oracle
SQL