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 reviews the logic and performance of some novel submissions to a reader challenge involving joining between two tables based on closest match.
Itzik Ben-Gan continues his series on solving a reader challenge involving joining between two tables based on closest match, looking at memory-optimized tables and SQL CLR.
Itzik Ben-Gan steps through an interesting reader submission for his "Special Islands" challenge from last month, with some surprising performance implications.
Continuing his series on optimization thresholds, Itzik Ben-Gan dives into the calculations behind stream aggregate costing when the data needs to be sorted first.
