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.