SQL Server Fabiano Amorim in SQL Server 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... 04 January 2012 12 min read