Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts with tag statistics Rss

Search for any content tagged statistics

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

   Items 1 to 12 of 12   
 

Enhanced Index Rebuild Script

Enhanced version of Index Rebuilt Script originally written by Michelle Ufford, which now includes latest version updates and additional features.  Read more...
Rating: |  Discuss |   Briefcase | 1,073 reads

Duplicate Stats

Give list of Duplicate Stats up to 9 cols...not just dupes but also covering...if one stats covers another its listed. Given pair only listed once if dupe.  Read more...
By John Heimiller 2015/08/26 | Source: SQLServerCentral.com | Category: statistics
Rating: |  Discuss |   Briefcase | 872 reads

Generated script to update statistics

Generated script to update statistics  Read more...
By Andrés Michaca 2014/05/02 | Source: SQLServerCentral.com | Category: statistics
Rating: |  Discuss |   Briefcase | 1,673 reads

Dynamically create drop user statistics scripts

Generate script to drop any unwanted user created statistics.  Read more...
By David Kranes 2015/02/24 | Source: SQLServerCentral.com | Category: statistics
Rating: |  Discuss |   Briefcase | 1,458 reads

Signal and Resource Waits

Calculates the signal and resource waits as a percentage of overall wait time.  Read more...
Rating: |  Discuss |   Briefcase | 1,353 reads

Missing Indexes By Index Advantage

Identifies potentially missing indexes.  Read more...
Rating: |  Discuss |   Briefcase | 4,311 reads

List Unused Tables and Indexes

Finds tables and indexes that do not show up in the usage statistics.  Read more...
Rating: |  Discuss |   Briefcase | 3,287 reads

Clear Wait Statistics

Clears the wait statistics so that the results of the 'Signal and Resource Waits' scripts are more relevant  Read more...
Rating: |  Discuss |   Briefcase | 1,819 reads

Object Explore

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.  Read more...
By Robin van Schaik 2010/08/24 | Source: SQLServerCentral.com | Category: data exploration
Rating: |  Discuss |   Briefcase | 1,040 reads

Update statistics in all databases

Simple script for update statistics in all databases  Read more...
By adeilsonrbrito 2010/04/16 | Source: SQLServerCentral.com | Category: statistics
Rating: |  Discuss |   Briefcase | 2,828 reads

Drop user statistics

This procedure drops all manually added statistics (field user_created=1)  Read more...
By Wilfred van Dijk 2009/06/11 | Source: SQLServerCentral.com | Category: maintenance
Rating: (not yet rated) |  Discuss |   Briefcase | 602 reads

SQL Server Backup, Integrity Check, Index and Statistics Maintenance

Solution for Backup, Integrity Check, Index and Statistics Maintenance in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 and SQL Server 2014.  Read more...
By Ola Hallengren 2014/10/20 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 44,568 reads
   Items 1 to 12 of 12