September 11, 2012 by Jugal Shah 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' About these ads Share this:Like this:Like Loading...