March 5, 2013 at 10:18 pm
How to disable AUTO_CREATE_STATISTICS and AUTO_CREATE_STATISTICS for all databases in single step?
March 5, 2013 at 11:43 pm
select 'ALTER DATABASE ' + Name + ' SET AUTO_UPDATE_STATISTICS OFF ' from sys.databases where database_id > 4
Copy the result of above query in run window and execute
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 6, 2013 at 12:22 am
Why do you want to do that? Are you aware of the impact that will have on query performance? Do you have jobs in place to manually create and update the statistics as necessary?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy