You always wanted to know how to pass arrays to SQL Server? Watch this Ultimate Guide to Table-Valued Parameters! Hello and welcome! My name is Vedran Kesegić and this video is an absolute “must” for database developers. Fast performing database …

How to pass arrays to SQL? TVP – The Ultimate Guide Read more »

Tagged with: , , , , , , ,

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:

Tagged with: , , , ,