Script Download:

This T-SQL script will check SQL Server stale statistics that may cause performance issues.

Some people asked how to find stale statistics for these statistics may cause performance issues. This T-SQL script will demo how to check stale statistics which have been updated for more than 1000 times in SQL Server 2008 R2 starting with Service Package 2 or SQL Server 2012 starting with Service Package 1.

image image

You can find more All-In-One Script Framework script samples at