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.
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.