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 adds another post to his series on T-SQL pitfalls and best practices series, treating complications and limitations of the PIVOT and UNPIVOT operators.