Accountant turned Accidental DBA. Financial Manager and Accounting Partner during the day and SQL scripter during the night.
Window Functions appear to be generally underutilised in the real world. Compared to CTE's and basic Select queries, one seldom sees Window Functions in SQL blogs, stackoverflow pages, forums, etc. (unless the article is dedicated to Window Functions). My opinion is that this is due to the syntax and different way of thinking about Window Functions compared to normal SQL syntax and use. This talk aims to change the way we think about Window Functions so that listeners can understand where to utilise them and hopefully how to speed up their own queries by opting to use Window Functions instead of Inner Joins or unecessary CTE's.
Code available at https://gist.github.com/IllusiveMilkman/70c319d60756b78dc11366ffdb5127b3
- 2018 October 9 11:20
- 40 min
- South Africa 2018