Adventure – Performance Edition

Target Audience:

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.

Abstract:

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;
– Indexes
– Query Design
– Settings that might affect performance
– Scalar Functions
– SARGability
– 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.

Additional Resources:

The following two tabs change content below.
I'm a performance tuning DBA who loves polishing up SQL Servers.

Latest posts by Rich Benner (see all)

Previous Post
Scrape Reddit for Testing Data using SQL Server & Python
Next Post
Certification Exams Inside Out

2 Comments. Leave new

Eugene Meidinger
September 14, 2019 8:51 am

I like the idea of letting the audience decide where to go next. I definitely you could highlight the benefits of that more. More than being an interesting gimmick, it allows the audience to learn about whatever they are most interested in. It also is an opportunity to answer people’s questions about performance tuning. You should really highlight that ans answer the “What’s in it for me?” question more explicitly.

Reply

I’ve been doing a similar session around Europe for the last 18 months.

Be aware that the CYOA is heavily trademarked, and the company who own it have recently put in a big claim against a large television streaming company

Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.

Menu