The SQL Server Performance Tasting Menu

Target Audience:

People who want to write smarter queries.

Abstract:

You’re a DBA or Developer, and you’ve been using SQL Server for a few years.

You know there are different ways to make queries faster, but you’re not sure when to use them.

I’m Erik Darling, and I’ll be your sommelier for the evening.

Over several courses of delicious demos, I’ll show you the types of performance problems different tuning techniques pair well with, and which ones to avoid.

When we’re done, you’ll understand exactly what patterns to look for when you’re troubleshooting slow queries, and how to approach them.

You’ll have the secret recipe for gourmet queries.

Why I Want to Present This Session:

I love tasting menus. Each dish is its own little experience, and the next one doesn’t have to complement the one before it. That’s how this talk is structured: It doesn’t tell a story, it’s just some demos I’m really proud of.

The following two tabs change content below.

Erik

Latest posts by Erik (see all)

Previous Post
Locks, Blocks, and Snapshots: Maximizing Database Concurrency
Next Post
Demystifying Dynamic SQL

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