Continuing his treatment of NULLs in SQL Server, Itzik Ben-Gan covers how SQL Server's implementation of unique constraints differs from the standard, and how you can work around it.
Itzik Ben-Gan continues his mind-bending series on NULL complexities in T-SQL, treating a variety of constructs including most people's nemesis, the MERGE statement.
Erin Stellato shows how to analyze patterns in your workload when dealing with many short, resource-intensive queries, a scenario commonly referred to as "death by a thousand cuts."
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.