How statistics creates automatically???
How statistics creates automatically on my production server table in sql server 2008???
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Jignesh TrivediPosted Nov 21, 2013, 10:52 PM
hi,
There is on property of Database to update Statistics automatically...
go to
select any database right click and select property
go to option tab.... there are two properties called "Auto Update Statistics" and "Auto Update Statistics async"
the property called "Auto Update Statistics" must set to true to auto update Statistics.
Please refer
http://blogs.msdn.com/b/buckwoody/archive/2009/08/18/sql-server-best-practices-auto-create-and-auto-update-statistics-should-be-on-most-of-the-time.aspx
hope this will help you.