SQLAuthority News – Solid Quality Journal – Importance of Statistics

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?

Download Importance of Statistics

Reference: Pinal Dave (https://blog.sqlauthority.com)

SQL Scripts, SQL Statistics
Previous Post
SQL SERVER – SQL Server Migration Assistant (SSMA) – Tools – Video – Download
Next Post
SQL SERVER – Denali – ObjectID in Negative – Local TempTable has Negative ObjectID

Related Posts

1 Comment. Leave new

  • why SQl Server Service is Stop unexpectedly,pls give me answer which is to the point


Leave a Reply