SQL Server Database File Sizes

This script creates a SQL_Statistics table in the Mater Database and then scroll through the existing databases on the server and gathers the Servers Name, logical device name, the file name and the file size and writes it to the table alond with a date time stamp.We run it once a month to gather the […]

2005-02-22 (first published: )

519 reads

Blogs

Daily Coping 13 Jul 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

Last Week Reading (2020-07-12)

By

Press Azure resource providers operations List of all of the available ADF-specific RBAC permissions....

Daily Coping 10 Jul 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Creating a Dimension with no Primary Key

By daithiboy

Hi all, I'm rebuilding some cubes in SQL Server 2017 using Visual Studio and...

Code signing a dll with certificate for use in SQL Server 2016

By fafful

I have a dll that will perform some webservice calls function. in order to...

Find whether a clustered index is actually unique

By DamianC

Hi   I have a table that has a clustered index on it The...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers