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?
SQL SERVER – What is Logical Read?
Comprehensive Database Performance Health Check and they asked me a question about logical read based on my previous video about SET STATISTICS IO.