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.
DBAs from the client’s organization ended up an argument about how T-SQL works. The discussion was about the epic confusion about TOP and DISTINCT.
Recently while working with my client I ended up in a very interesting situation where my client wanted me to write an Efficient Query.
Do you know what a single arrow means in an execution plan? While we popularly call it the arrow, there is a technical name for these little arrows.