Itzik Ben-Gan is a T-SQL trainer and a co-founder of Lucient. A Data Platform Microsoft MVP (Most Valuable Professional) since 1999, Itzik has delivered numerous training events around the world focused on T-SQL Querying, Query Tuning and Programming. Itzik authored many articles and books including T-SQL Fundamentals and T-SQL Querying. Itzik’s speaking activities include SQLPASS, SQLBits, and other Microsoft Data Platform events. Itzik is the author of Lucient’s Advanced T-SQL Querying, Programming and Tuning and T-SQL Fundamentals courses along with being a primary resource within the company for their T-SQL related activities.
Itzik Ben-Gan takes an interesting look at new bit manipulation functionality in SQL Server 2022, including GET_BIT, SET_BIT, RIGHT_SHIFT, and LEFT_SHIFT.
Itzik Ben-Gan shows two supported approaches to mimic the GROUPS window frame option, which is part of the SQL standard but currently unsupported in SQL Server.
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.
