I just finished this particularly awesome new Ben-Gan article about the Batch Mode Window Aggregate Operator in SQL Server 2016. He refers to this as the third major milestone in SQL Server's support for Windows functions (the first being their introduction in 2005, the second was framing and windowing in 2012). The article is a goldmine of content about speeding up window functions.
I'd love to see articles about the the Batch Mode Window Aggregate Operator and how to leverage these window function performance enhancements.
"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."-- Itzik Ben-Gan 2001