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

Additional Resources:

The following two tabs change content below.
I'm a performance tuning DBA who loves polishing up SQL Servers.
Previous Post
Scrape Reddit for Testing Data using SQL Server & Python
Next Post
Disposable Development environments with Azure DevOps and Azure Resource Manager Templates

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