» t-sql tuesday
» sql improvements (RSS)
Sorry, but there are no more tags available to filter with.
SQL 2012 brings us a bunch of new analytic functions, together with enhancements to the OVER clause. People who have known me over the years will remember that I’m a big fan of the OVER clause and the types of things that it brings us when applied to aggregate functions, as well as the ranking functions that it enables.
The OVER clause was ...
Interestingly, my favourite new feature of SQL Server 2008 R2 isn’t any of the obvious things. You may have read my recent posts about how much I like some of the new Reporting Services features, such as the map control. Or you may have seen my presentation at SQLBits V on StreamInsight, which I think has great potential to change the way ...