My article on “Important of Statistics” has been published in Solid Quality Journal.
Statistics are a key part of getting solid performance. In this article we will go over the basics of the statistics and various best practices related to Statistics. We will go over various frequently asked questions like when to update statistics and difference between sync and async update of statistics. We will also discuss the pros and cons of the statistics update.
I have answered one very important questions in this article:
Should keep Auto Create Statistics and Auto Update Statistics settings true/on?
Reference: Pinal Dave (http://blog.SQLAuthority.com)