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.
The question is about JOIN Elimination for Not Selected Column. It was discussed in the Comprehensive Database Performance Health Check.
Why the result we get is the result we get. The answer is very simple – it is because of the Logical Processing Order of the SELECT Statement.
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?