SQL Server Denali includes some new tricks in its T-SQL bag. In this week’s Technology Triage Tuesday webcast, Jeremiah Peschka explains aggregations – formulas that do something to transform many numbers into one number that has meaning:
For more details, check out Jeremiah’s post on Leaving the Windows Open.
bonskijr August 24, 2011 | 9:05 am
Nice intro to Denali windowing functions, I wish the font size would be cranked up(say 13-16pts) during code demo.
thanks
Jeremiah Peschka August 24, 2011 | 9:07 am
I’m glad you liked it, but sorry that the font size is a bit rough on the video during the demos. The examples are available at http://brentozar.com/go/windows, so you should be able to view them at your own pace.
Oscar Zamora August 25, 2011 | 9:54 pm
Just recalled my development in Oracle 9i. Nice to see that MSFT is catching up with needed functionality.
Is RATIO_TO_REPORT included in Denali?
Jeremiah Peschka August 26, 2011 | 9:50 am
Unfortunately, RATIO_TO_REPORT is not in Denali. It’s not part of the SQL standard either, as far as I can tell. From a quick look at what it does, I’m thinking you could fake your own version of it pretty quickly with a subquery or CTE.
Pingback: Something for the Weekend – SQL Server Links 26/08/11
Todd Everett August 26, 2011 | 9:28 am
Extremely helpful video and examples! As an old time SQL Coder who has seen some OVER clauses in SQL I had to review and didn’t understand it, your presentation is the first explanation I have really understood. Thanks!
Jeremiah Peschka August 26, 2011 | 9:52 am
I’m glad to hear that it helps you out! I love what the window functions can do, so it made my day to hear that my presentation was the first explanation you understood. Thanks so much for the kind words on a Friday morning!