If you are a SQL Server 2012 developer, you may not be so interested in Always-on High Availability and “Big Data,” the focus of the marketing hype for SQL Server 2012, but you'll love the enhancements to the SQL Windows functions. This is the real big-ticket item.
SQL Server 2005 ushered in the first ANSI-standard Windows ranking and aggregate functions, along with the
OVER clause, which allowed us to apply the functions across each row in a specified window/partition of data. The use of
OVER alongside the new Common Table Expressions (CTEs), made for a revolutionary change in the way that one could develop T-SQL solutions. Still, certain procedures, such as the rolling balance calculation, ...