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.
Jeremiah Peschka
Jeremiah Peschka has worked as a database and emerging technology expert at Quest Software where he researched new trends and technologies in the world of data storage. Over the course of his career he’s worked with companies across many industries as a system administrator, developer, and DBA. He’s been involved with all aspects of application development and deployment. He likes cheesecake, coffee, and ice cream.
Follow Me:
Nice intro to Denali windowing functions, I wish the font size would be cranked up(say 13-16pts) during code demo.
thanks
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.
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?
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.
[...] Video: How to Use the Denali Windowing Functions - New functionality coming our way in Denali, Jeremiah Peschka (Blog|Twitter) explains all. [...]
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!
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!