• The Lead/Lag functions were one of the main reasons we upgraded to SQL 2012. We had a process that went from running for 45 minutes daily to running in 4 minutes using LAG. 😀