My client reached out to me asking if there is a way to measure the performance of the newly created index. How to measure index performance.
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?