Script Download: CheckStaleStatics.zip
http://gallery.technet.microsoft.com/How-to-check-SQL-Server-4fefea34

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
 image

You can find more All-In-One Script Framework script samples at http://aka.ms/onescriptingallery