Tag: statistics
-
T-SQL Script to Check the ‘Auto Update Statistics’ Option for Each DB in an Instance
[sourcecode language=”sql”] /* Script to check if AutoUpdateStats option is turned on for all the DB’s in an instance. Note: you have to take the output from the following script and run it again to get the final results. */ –SQL2000 select ‘select ”’ + name + ”’ as DB_Name, databasepropertyex(”’ + name + ”’,…