Technical Article

SQL 2000 Data & Log file info for all DB's

Returns information about all the data / log files on a server, such as total file size, % used & free, etc.Can be set to filter out db's you don't want to monitor.When edited to allow the "update usage", numbers reported will be more accurate.Note: if you edit to allow update usage and intend to […]

You rated this post out of 5. Change rating

2006-01-12 (first published: )

349 reads

Blogs

Speaking at SQL Saturday Boston 2023

By

I’m heading to Boston next week for SQL Saturday Boston 2023. I went to...

SQL Prompt Quick Access to Helper Code

By

We’ve been doing some events as part of the Redgate Roadshow, and at one...

Eleven chapters of my data architecture book are available

By

As I have mentioned in prior blog posts, I have been writing a data...

Read the latest Blogs

Forums

Closing a Symmetric Key

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Closing a Symmetric Key

I can query one by one. Need help how to become Single Query

By Adelia

Hi, This is my table and data, CREATE TABLE [dbo].[rpt_AR_StatementOfAcct_003]( [Id] [int] IDENTITY(1,1) NOT...

Baking up and restores VLDBs

By ericwenger1

Some of our databases are getting be close to 2 terabytes. We are backing...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers