07 t-sql-queries table-expressions-part-4 2020 Related Topics 
SQL Performance
AUGUST 12, 2020
This article is the fifth part in a series about table expressions. In Part 1 I provided the background to table expressions. In Part 2 , Part 3 , and Part 4 , I covered both the logical and the optimization aspects of derived tables.
SQL Performance
AUGUST 1, 2022
Recently I covered some of the T-SQL improvements in SQL Server 2022 here , and Aaron Bertrand covered additional improvements here. Microsoft just announced the release of SQL Server 2022 CTP 2.1. This release includes a number of additional interesting T-SQL improvements, which include: The distinct predicate.
Expert insights. Personalized for you.
140 
Let's personalize your content