Itzik Ben-Gan dives deep on two of the more interesting T-SQL enhancements in SQL Server 2022: the new WINDOW clause and the windowing NULL treatment clause.
Queries with multiple ordering needs typically involve sorts in their plans. By following these tips, you can minimize the number of needed sorts. Learn more.
Paul White continues his series on simple parameterization and trivial plans with a look at the data types assigned to parameters. Learn more in part 2.
