Today I am going to share our very interesting conversation about sp_updatestats and Disabled Nonclustered Indexes. Let us discuss.
The question is about JOIN Elimination for Not Selected Column. It was discussed in the Comprehensive Database Performance Health Check.
Recently I had encountered an interesting issue with one table where we had to disable statistics update for a single table. How we can do that?
Is it possible that your statistics are many years old but still are valid? It is difficult to find Outdated Statistics is not as easy as it seems.