T-SQL supports four kinds of named table expressions: derived tables, CTEs, views and inline table valued functions. From a query tuning perspective, SQL Server treats table expressions very differently compared to persisted tables. This session provides query tuning tips concerning table expressions, and shows you how to apply those tips to address common query tuning needs.
Sign up to get the latest conference information, announcements and price bump reminders direct to your inbox.
Redgate will only contact you about PASS Data Community Summit and SQL Saturday, unless you separately request emails about Redgate.
2021 Summit video library