How statistics creates automatically???

Question

How statistics creates automatically on my production server table in sql server 2008???

Jignesh Trivedi · Answer

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.