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)
362 reads
2015-11-26 (first published: 2015-11-02)
3,660 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,304 reads
Size of database files for an instance of SQL Server
2014-05-07 (first published: 2014-04-10)
1,268 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,503 reads
2008-07-23 (first published: 2008-06-05)
1,205 reads
2005-01-18
Hi bdohmenThanks a lot for your help. Your reply was exactly what I needed and it now works a treat.Brendan
2004-08-25
Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/column
2004-05-24
2 reads
Just Create A tempTable with the structure of the Recordset returned by the sp and use the insert exec construct like:declare @TimesToRun int ,@blkidM int ,@blkid1 int ,@blkid2 int ,@blkid3 int set @TimesToRun = 3set @blkid1 = 218645set @blkid2 = 218646set @blkid3 = 218647set @blkidM = @blkid1 Create Table #T (fld1 ,fld2 ,fld3..) while @TimesToRun > […]
2004-04-01
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
At a recent conference I was asked how I executed code during my presentation....
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers