Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
Scripts with tag
statistics
Search for
any
content tagged
statistics
Add a script
Items 1 to 8 of 8
Signal and Resource Waits
Calculates the signal and resource waits as a percentage of overall wait time.
Read more...
By
SQL Scripts Manager dev team
2013/06/18
|
Source:
SQLServerCentral.com
|
Category:
dmv
|
SQL Scripts Manager Compatible
Rating:
|
Discuss
|
Briefcase
|
1,155 reads
Missing Indexes By Index Advantage
Identifies potentially missing indexes.
Read more...
By
SQL Scripts Manager dev team
2013/06/18
|
Source:
SQLServerCentral.com
|
Category:
dmv
|
SQL Scripts Manager Compatible
Rating:
|
Discuss
|
Briefcase
|
3,435 reads
List Unused Tables and Indexes
Finds tables and indexes that do not show up in the usage statistics.
Read more...
By
SQL Scripts Manager dev team
2013/06/18
|
Source:
SQLServerCentral.com
|
Category:
dmv
|
SQL Scripts Manager Compatible
Rating:
|
Discuss
|
Briefcase
|
2,896 reads
Clear Wait Statistics
Clears the wait statistics so that the results of the 'Signal and Resource Waits' scripts are more relevant
Read more...
By
SQL Scripts Manager dev team
2013/06/18
|
Source:
SQLServerCentral.com
|
Category:
dmv
|
SQL Scripts Manager Compatible
Rating:
|
Discuss
|
Briefcase
|
1,363 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,002 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,666 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
|
531 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, and SQL Server 2012.
Read more...
By
Ola Hallengren
2013/03/13
|
Source:
SQLServerCentral.com
|
Category:
backup
Rating:
|
Discuss
|
Briefcase
|
38,726 reads
Items 1 to 8 of 8
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.