Your level of knowledge on performance tuning doesn’t matter, a passing idea of what’s happening is all you need. In the session we’ll cover each topic a little but I will also provide a more in-depth explanation of everything we go through after the session if you want to learn more.
Remember those adventure books from when we were little where you would have multiple choices and see where the story takes you? Yep, that’s what we’re doing in this session.
We’re going to start with a poorly performing query and choose which route we’re going to take to see if we can make it better. This will be voted by you at every stage so we’ll learn about whatever is voted for, this could go any direction!
You don’t need any previous experience in performance tuning for this session, we’ll briefly cover each topic as it’s chosen.
Potential topics include;
– Query Design
– Settings that might affect performance
– Scalar Functions
– Temp Tables
The voting will be done live by everybody who wants to participate, let’s see where this adventure takes us.
Why I Want to Present This Session:
I love performance tuning, I do it every day. This should be a fun way of seeing how each decision we make while performance tuning affects our query the most.
Latest posts by Rich Benner (see all)
- Adventure – Performance Edition - August 12, 2019
- Scrape Reddit for Testing Data using SQL Server & Python - March 5, 2019
- Making Your Emergency Toolkit - April 12, 2018