I have a simple script that will list all the long running queries in the database with the execution plan. Well, the answer is yes.
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?