Update statistics

Hi Team,<o:p></o:p>

                we have upgraded sql server 2008 R2 to SQL server 2012 SP2. Now in order to Execute UPDATE STATISTICS in user-defined tables in SQL Server user databases,  can anyone share us a script as we have around 126 databases on this server.<o:p></o:p>

<o:p> </o:p>

Regards,

Varun


September 10th, 2015 2:53am

Hello Varun,

Just run sp_updatestats (Transact-SQL) to update all statistics of all tables.

Free Windows Admin Tool Kit Click here and download it now
September 10th, 2015 3:02am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics