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.
Aaron Bertrand talks about the top 10 wait types we see among our SentryOne customer base, and where to turn when you're experiencing one of them on your own system.
For this month's T-SQL Tuesday, Aaron Bertrand shows that when triggers are necessary, in some cases INSTEAD OF triggers can be better for performance than AFTER triggers.
