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 “choose your own adventure” books from when we were little? 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.
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
We’ll be voting on where we go at each step to see where our journey 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)
- Choose your own 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