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.