In this lab, we’ll learn about how a query is logically and physically processed in SQL Server. In the first exercise, we will learn about logical execution order of the statements in select clause. In the second exercise, we will learn how the query is physically processed.
Exercise 1: Logical Query Processing
Exercise 2: Physical Query Processing