Refactoring T-SQL with Windowing Functions

You’ve been querying comparative numbers like Year To Date and Same Period Last Year by using tedious CTEs and subqueries. Beginning with SQL Server 2012, getting these numbers is easier than ever! Watch a 30-minute T-SQL tune-up using window functions that will cut down dramatically on the amount of code you need to write.

Video producer: http://www.brentozar.com/