This session focuses on named table expressions; specifically, derived tables, CTEs, views and inline table valued functions. The session tries to clear out some confusion that exists around these constructs in the SQL Server community. It explains both the logical aspects of table expressions as well as optimization considerations.
level: 300
