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