Logical Query Processing

This is not about how SQL queries be executed under the hood of a DBMS but it explains in which order different SQL operators are processed, particularly in SQL Server. All credits go to the author: Itzik Ben-Gan’ in Inside Microsoft Sql server 2008 t-sql Querying book.