Update Statistics Useful Scripts


Script to find out the statistics update date for all the indexes in the current database

sp_MSforeachtable 'sp_autostats "?"'

Script to update the statistics of all the indexes

EXEC sp_MSforeachtable 'UPDATE STATISTICS ? WITH FULLSCAN'

Thanks for the comment, will get back to you soon... Jugal Shah