In this video, I take you through some of the limitations of window functions in SQL Server, including the lack of intervals and oddities around the APPLY operator.
Intervals would be a really powerful addition to SQL Server’s window function capabilities, but I’m not going to hold my breath for them.