SQL Order of execution

A look at how the SQL engine executes queries and how we can use this knowledge

Did you know that SQL Servers internal order of operations does not start with SELECT? Understanding what is going on under the hood will enable T-SQL newbies and those that don't code "all that much" to write better and more efficient code off the bat.