Technical Article

Get Data/Log File Names, Sizes, Percent Utilization--ALL DBs

This Stored Procedure Will Get: - The Data and Log File Names - The Data and Log File Sizes (MB) - The Data and Log Percent Utilization (%) for ALL Databases on a SQL Instance. Numbers Should (More Or Less) Reflect What You See on The SQL Enterprise Manager Taskpad. LIMITATIONS: For Databases With Multiple […]

2005-02-14 (first published: )

1,138 reads

Blogs

Daily Coping 20 May 2020

By

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

Daily Coping 19 May 2022

By

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

Running dynamic SQL in a different database

By

This is one of those things that on hindsight was a stupid problem, but...

Read the latest Blogs

Forums

min and max startdate

By Shree23

Hi Expert, I wanted to calculate max date for prodstatus =5 - min date...

Azure DE Interview scenario/case questions

By kinporsch

Hello guys, I am preparing for Azure DE positions with Data Factory, Databricks, Synapse....

MS SQL Server 2012 question regarding SSIS

By ageilmelo

OK so I have a customer with a hosted website with eCommerce options. Essentially...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers