Have SUM() fun!

Have SUM() fun!

Did you know that SUM() aggregate can be used together with OVER() clause?

A short intro to windowing functions:

The result is graphically visualized by using only SQL Server Management Studio and unicode characters:

… or spatial data type:

One practical example of this method is visualizing SQL Agent Jobs from Daniel Hutmacher – very useful to make a better job schedule.

Watch the video and give it a thumbs up if you like it:

Entire demo script is here.

Tagged with: , , , ,

Leave a Reply

Your email address will not be published. Required fields are marked *

*

This site uses Akismet to reduce spam. Learn how your comment data is processed.