Could you please let me know if the 'below script/code' OR..'Auto Update statistics'= True ( DB - Properties-Options ) does the SAME work for the specific DB. I see the below code running for some databases in SQL agent job. Now my questions is if we just set the Auto Update statistics = True on the desired databases there is no need for the job running with below code and added work for sql server? please let me know if I am missing anything here..Thanks!
@ Databases = 'AdventureWorks', -- or any other DB and add a step in agent with the same code and new DB name..
@FragmentationLow = NULL,
@FragmentationMedium = NULL,
@FragmentationHigh = NULL,
@UpdateStatistics = 'ALL'
- This topic was modified 11 months ago by sizal0234.