SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

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)

Statistics not updated for the last 30 days

By Yusuf Kahveci,

We want to keep them up to date as we know that statistics are vital for our Performance. So I will share with you the script below that you can follow and update our statistics.
In the script below you can find the statistics that have not been updated for 30 days and can automate your process accordingly.
Yusuf KAHVECI
yusufkahveci@sqlturkiye.com
www.sqlturkiye.com
Thanks.

Total article views: 2087 | Views in the last 30 days: 173
 
Related Articles
FORUM

Statistics

Statistics-Sql server 2K

FORUM

Statistics

Experiments with multi-column statistics

FORUM

query statistics

query statistics

FORUM

Statistics update

Statistics update

FORUM

suspended statistics

suspended statistics

Tags
bottlenck    
healthcheck    
performance    
sql    
statistics    
tuning    
 
Contribute