Sql

Search

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'

Comment

PREVIOUS	NEXT

Code Example
Sql :: GROUP BY With HAVING Clausel
Sql :: sql in
Sql :: sql server split string last
Sql :: minus in sql
Sql :: INITCAP in Oracle example
Sql :: encrypt and decrypt in sql server
Sql :: sql left
Sql :: how to write lowercase in sql
Sql :: postgresql default value
Sql :: mysql how to use FIND_IN_SET function in WHERE clause ?
Sql :: oracle select row max date
Sql :: psql no such file or directory
Sql :: ms sql mac
Sql :: create empty table from existing table
Sql :: sql string function update replace
Sql :: sql primary key syntax
Sql :: mac django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb module. Did you install mysqlclient?
Sql :: SQL select example
Sql :: t sql dynamic top n query
Sql :: select all tables linked server sql
Sql :: sql where contains part of string
Sql :: update value sql
Sql :: installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1
Sql :: sql script to remove default from column
Sql :: sql insert values into table
Sql :: delete table cassandra
Sql :: sql vs nosql or mysql vs mongodb
Sql :: Sequelize model datatype of enum
Sql :: case statement in select query in sql
Sql :: export database sql file from xampp using cmd

Search

SQL

ms sql database data size

ADD CONTENT