Task 6: T-SQL Window Functions

• Based on my SQL Server 2012 exam I started looking for some information about enhancements for this topic. I found a new book by Itzik Ben-Gan regarding T-SQL Window Functions with the following chapters: 

          1. SQL Windowing  
          2. A Detailed Look at Window Functions
          3. Ordered Set Functions 
          4. Optimization of Window Functions 
          5. T-SQL Solutions Using Window Functions 

• The book has only 200 pages and it's pretty easy to scan it in order to find useful information. Good luck.