I'll write more about this when I get the chance. But in the meantime, if you want the slides and scripts from my presentations in Wagga and at AdSSUG last week, then get them from http://msmvps.com/files/folders/robfarley/entry180018.aspx . It was on Ranking Functions and Windowing, or on the uses of the OVER clause, etc.
Blog posts!
Opinion pieces and technical analysis from Rob Farley and other LobsterPot employees from the last 20 years
LobsterPot Blogs
Blog posts by Rob Farley and other LobsterPot Solutions team members.
Recent Posts
Risk and Reward of SQL Indexes
October 13, 2026
Outages to remember
September 8, 2026
Temp tables – a blessing or a curse?
August 11, 2026