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.
Itzik Ben-Gan describes nested window functions and how they could simplify some tedious query scenarios. He asks for your help voting for these to be included in SQL Server.
Itzik Ben-Gan asks you to invest in SQL Server's future by voting for Row Pattern Recognition, a potential T-SQL syntax extension he deems the next step in the evolution of window functions.
