In the final post for this series, we'll talk about statistics maintenance. Unlike indexes, statistics don't become fragmented, but the histograms associated with those statistics become out of date as the data in the column changes.
While statistics maintenance is important, you have to keep in mind that updating stats can also cause plan recompilation and that has costs of its own.
I designed the solution for the most mission-critical environments, and it is used in many organizations around the world.
If due to any reason you think that your statistics outdated and you want to update them, you can run following statement.In SQL Server 2008 R2 SP1, trace flag 2371 was introduced.This trace flag causes that 20% threshold to change dynamically once the row count surpasses ~25,000 rows, meaning you will get more predictable updates based on the same churn.Dear readers, Please find the interview question and its answer based on statistics in SQL Server.How to find auto update statistics and auto update statistics asynchronously options in SSMS: Right click on your database– ——Scripts ——Scripts