SQLpassion BLOG

SQL Server Windowing Functions: ROWS vs. RANGE

Almost every time that I present about Windowing Functions in SQL Server, people are very interested in knowing the difference between the ROWS and RANGE option when you define your window frame. Therefore I want to show you in today’s blog posting the difference between those options, and what it means to your analytic calculations. …

SQL Server Windowing Functions: ROWS vs. RANGE + read more

SQL Server Performance Tuning Workshop in London, June 2015

I’m very happy to announce today that I will be back with my already famous SQL Server Performance Tuning Workshop in London this year! This 5-day long workshop is scheduled from June 1 to June 5 in Central London. Besides London I also run this workshop in Utrecht/Netherlands from April 13 – 17. There are …

SQL Server Performance Tuning Workshop in London, June 2015 + read more