SQLServerCentral.com Scripts tagged statistics

Signal and Resource Waits

Wed, 22 Dec 2010 15:38:03 UT

Calculates the signal and resource waits as a percentage of overall wait time.

Missing Indexes By Index Advantage

Wed, 22 Dec 2010 15:35:49 UT

Identifies potentially missing indexes.

List Unused Tables and Indexes

Wed, 22 Dec 2010 15:33:14 UT

Finds tables and indexes that do not show up in the usage statistics.

Clear Wait Statistics

Wed, 22 Dec 2010 15:31:24 UT

Clears the wait statistics so that the results of the 'Signal and Resource Waits' scripts are more relevant

Object Explore

Tue, 24 Aug 2010 06:00:00 UT

summary information and metrics for any column in a given Table/View. Metrics include: number of records, distinct records, nulls, min, max, std, quartiles, kurtosis, skew, etc.

12 essential tools for database professionals
The SQL Developer Bundle contains 12 tools designed with the SQL Server developer and DBA in mind. Try it now.

Update statistics in all databases

Fri, 16 Apr 2010 06:00:00 UT

Simple script for update statistics in all databases

Drop user statistics

Thu, 11 Jun 2009 06:00:00 UT

This procedure drops all manually added statistics (field user_created=1)

12 essential tools for database professionals
The SQL Developer Bundle contains 12 tools designed with the SQL Server developer and DBA in mind. Try it now.

SQL Server Backup, Integrity Check, Index and Statistics Maintenance

Wed, 13 Mar 2013 06:00:00 UT

Solution for Backup, Integrity Check, Index and Statistics Maintenance in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, and SQL Server 2012.