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: )

517 reads

Blogs

Containers: Create a Custom Container

By

Creating a custom container is where things get truly exciting. There’s actually a ton...

Mini-Rant: Spoofed Phone Numbers and Trust

By

I’ve seen this more and more over the last year: I receive a phone...

Speaking at SQL Saturday Dallas

By

Speaking at SQLSaturday Dallas! I’m proud to announce that I will be speaking at SQL...

Read the latest Blogs

Forums

The Change Failure Rate

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Change Failure Rate

insert and update

By girl_bj

Hi, need some advice. I have more than 20 columns and more than 50k...

How to map the table data while inserting into another table in sql

By nagaraj

  table1 id   value 2    20 3    30 4    40 5 ...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers