Actually, I only submitted the winning entry; Denali CTP3 SQL Server 2012 is the real winner. After having a blog posted here recently about running totals performance in Denali CTP3 SQL Server 2012, I happened to run across this T-SQL Challenge for doing running totals. On a lark, I posted a Denali CTP3 SQL Server […]
Book List
Planned books:
None
Current books:
-
SQL Server 2012 T-SQL Recipes: A Problem-Solution Approach (Expert’s Voice in SQL Server) by Jason Brimhall, David Dye, Jonathon Gennick, Andy Roberts, Wayne Sheffield
-
SQL Server T-SQL Recipes by Jason Brimhall, Jonathan Gennick, Wayne Sheffield
Recent books:
None
Browsing Posts in Denali
This post is part of the series discussing the new Analytic functions in SQL Server “Denali”, CTP3. Analytic Functions in SQL Server “Denali” All of the new Analytic functions require the use of the OVER clause. To see what changes to the OVER clause that “Denali” brings, please view my article The OVER Clause enhancements in […]
This post is part of the series discussing the new Analytic functions in SQL Server “Denali”, CTP3. Analytic Functions in SQL Server “Denali” All of the new Analytic functions require the use of the OVER clause. To see what changes to the OVER clause that “Denali” brings, please view my article The OVER Clause enhancements in […]
This post is part of the series discussing the new Analytic functions in SQL Server “Denali”, CTP3. Analytic Functions in SQL Server “Denali” All of the new Analytic functions require the use of the OVER clause. To see what changes to the OVER clause that “Denali” brings, please view my article The OVER Clause enhancements in […]
This post is part of the series discussing the new Analytic functions in SQL Server “Denali”, CTP3. Analytic Functions in SQL Server “Denali” All of the new Analytic functions require the use of the OVER clause. To see what changes to the OVER clause that “Denali” brings, please view my article The OVER Clause enhancements in […]
♠This post is the first post in a series discussing the new Analytic functions in SQL Server “Denali”, CTP3, and it will also serve as the landing page for this series. (The information in this article may change when this version is released to RTM; however since the changes described adhere to the ANSI specification, […]
One of the things that I’m the most excited about in “Denali” CTP3 is the enhancements to the OVER clause. One of the things that I’m particular excited about is the addition of the ROWS/RANGE clause support. And one of the reasons that I’m excited about this is that this provides a supported, documented (in […]
