In my career, this is I think 2 or 3 rd time I have seen this one, so do not consider this as a generic solution. How to Disable Rowgoal Optimizer works?
SQL SERVER – Number of Rows Read – Execution Plan
Recently one of the clients sent me images from the execution plan and his question was about the Number of Rows Read in the SQL Server Execution plan.
SQL SERVER – Fill Factor – Instance Level or Index Level
One of the conversations that keep on coming up at what level one should set the fill factor – Instance Level or Index Level.
SQL SERVER – Long Running Queries with Execution Plan
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.
SQL SERVER – sp_updatestats Performance and Disabled Nonclustered Indexes
Today I am going to share our very interesting conversation about sp_updatestats and Disabled Nonclustered Indexes. Let us discuss.
SQL SERVER – JOIN Elimination for Not Selected Column
The question is about JOIN Elimination for Not Selected Column. It was discussed in the Comprehensive Database Performance Health Check.
SQL SERVER – Disable Statistics Update for a Single Table
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?