Understanding Named Table Expressions in T-SQL

Agenda

• 18:00-18:15 - Opening, Announcements, and More...

• 18:15-19:15 - Understanding Named Table Expressions in T-SQL

• 19:15-19:30 - Q&A

Session: Understanding Named Table Expressions in T-SQL – Itzik Ben-Gan (60 Minutes, Hebrew)

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.