SQLServerCentral.com Scripts tagged Storage

List all tables and their respective information.

Thu, 14 Mar 2013 06:00:00 UT

List all tables in a SQL Server database with the details of them.

Three Sample reports for the Automated DBA: Space Usage SnapShotter

Mon, 13 Jul 2009 06:00:00 UT

1100 largest indexes by total buffer cache usage; 100 largest tables by total reserved pages; Largest tables in each database with running total of space usage and growth since last snapshot

The Automated DBA: Batch Database File Grower - SQL2000 ReportOnly Ver

Fri, 19 Jun 2009 06:00:00 UT

Grows all of the data files in a database based on the greater of a fixed minimum free space amount or a dynamic percentage of the size of the largest table in the filegroup.

The Automated DBA: Batch Database File Grower - SQL2005 ReportOnly Ver

Mon, 22 Jun 2009 06:00:00 UT

Grows all of the data files in a database based on the greater of a fixed minimum free space amount or a dynamic percentage of the size of the largest table in the filegroup.

The Automated DBA: Batch Database File Grower - SQL 2000 Version

Thu, 25 Jun 2009 06:00:00 UT

Grows all of the data files in a database based on the greater of a fixed minimum free space amount or a dynamic percentage of the size of the largest table in the filegroup.

The Automated DBA: Batch Database File Grower - SQL 2005 Version

Tue, 23 Jun 2009 06:00:00 UT

Grows all of the data files in a database based on the greater of a fixed minimum free space amount or a dynamic percentage of the size of the largest table in the filegroup.

The Automated DBA: Space Usage Snapshotter Lite (non-sysadmin dbo)

Mon, 15 Jun 2009 06:00:00 UT

Records snapshots of space usage stats by partition, index, table, schema, filegroup, and database. Stats include Reserved, Used, and Data for row, lob, and overflow.

The Automated DBA: Space Usage Snapshotter (sysadmin; central DB)

Wed, 17 Jun 2009 06:00:00 UT

Records snapshots of space usage & buffer cache usage stats by partition, index, table, schema, filegroup, & database. Stats incl Reserved, Used, Data, buffer cache for row, lob, & overflow.

Table Information View -- No Cursors!

Fri, 28 Dec 2012 07:00:00 UT

Row counts and storage space information for all tables in the database. (SQL Server 2005).