SQL Server Window Function Performance: Execution Plans for Running Aggregates, LEAD, LAG, FIRST_VALUE, LAST_VALUE

Performance analysis of SQL Server window functions - comparing execution plans for running aggregations (OVER + ORDER BY), LEAD and...