sql server query database space available
Solutions on MaxInterview for sql server query database space available by the best coders in the world
{{#items}}
{{text}}
{{/items}} {{ctaText}}
{{#items}} {{/items}}
showing results for - "sql server query database space available"
Federico
21 Sep 2020
1SELECT DB_NAME() AS DbName,
2 name AS FileName,
3 type_desc,
4 size/128.0 AS CurrentSizeMB,
5 size/128.0 - CAST(FILEPROPERTY(name, 'SpaceUsed') AS INT)/128.0 AS FreeSpaceMB
6FROM sys.database_files
7WHERE type IN (0,1);similar questions
sql server standardsql server enterpriseplsql check how much space all databases are consumingsql server 2012 query historyhow to check sql server agent job historyhow to know the sql server editionversion and edition of sql server database enginesql query to find the table size mssqlsql database sizesql server size of every table in a dbcheck database restore status sql scriptms sql database data sizesql server list table sizeshow much space does sql server take per rowsearch all database tables for a value sqlservershow sql server databasesql database connectivityremove spaces sql serversql server table sizesql query to get column names and data types in sql serversql express database size limitsql server version querysql server cost fifo querysql server 3a query to find out all the places where the table is usedserver name sql server your answer for
you will get a confirmation link on this - you will have to click that for successful submission of your answer. we require this to keep the website free of spam, bots and unhelpful content
please ensure to add code which is syntactically corrent and executes properly
ask question on maxinterview
you will get a confirmation link on this - you will have to click that for successful submission of your question. we require this to keep the website free of spam, bots and unhelpful content
please be clear, to the point and respectful