This is quick script to ascertain datafile headroom based on current size of the data in a file against the max size (which needs to be set for this to work!)
2017-05-02 (first published: 2017-04-19)
376 reads
Gets the size, amount of space used & unused, owner and modify date for all databases in a Sql instance.
2015-09-14 (first published: 2014-04-22)
4,384 reads
Size of database files for an instance of SQL Server
2014-05-07 (first published: 2014-04-10)
1,300 reads
This script displays all data files within a SQL Server database with the following relevant properties: FileName, FileLocation, FileSizeMB, SpaceUsedMB, AvailableSpaceMB, %FreeSpace, FileGrowthMB and FileGroupName
2013-11-11 (first published: 2013-10-29)
1,517 reads
I spend my days working on and managing SQL Server instances—working days at least,...
Want to learn SQL and get some real practice this December? Check out the...
By Steve Jones
A new feature added to Redgate Monitor Enterprise automatically. CIS compliance is something many...
Hi I am trying to assign the value of the variable using the output...
Comments posted to this topic are about the item Merry Christmas 2025
Comments posted to this topic are about the item The Reindeer Count
How many reindeer does Santa have pulling his sleigh? (according to the famous song) Hint, the answers are not base 10.
See possible answers