they asked me questions if I know how to fix it. Well, it is actually very simple and we need to learn about Grid vs Text Output.
SQL SERVER – Disable Rowgoal Optimizer
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.
Line Numbers for SSMS Efficiency – SQL in Sixty Seconds #147
This is when the line numbers in SSMS comes in extremely handy and let us learn in today’s blog post how we can do that. Let us learn today.
Efficiency Trick – Query Shortcut – SQL in Sixty Seconds #143
I have built a new SQL in Sixty Seconds video which describes how Query Shortcut works and how we can change them. Let us learn today.
SQL SERVER – Query Shortcuts
One of my clients who hired me for the Database Performance Health Check got very impressed that I was able to use efficiently query shortcuts.
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.