PASS logo PASS Data Community Summit 2021
Host Redgate Premier sponsor Microsoft

November 8-12

Free online conference

All sessions

Every Millisecond Counts

Jared Poche

Jared Poche

Database Engineer - ChannelAdvisor

Query optimization is relatively easy when you look at a plan and find table scans, hash match joins, and missing indexes. But how do you find opportunities when all the low hanging fruit has been picked? This session is a case study on improving a procedure that runs 350 million times per day, so any improvement is greatly magnified. We will discuss where we found opportunities to improve a procedure running in 3.1 milliseconds; how effective our attempts were, what didn’t work, and the results achieved.

Type: General Session (60-minutes)

Theme: Back to Basics

Track: Development

Level: 200 (Intermediate)

Best of Summit 2020

Watch the top 2020 PASS Summit sessions from some of the best speakers in the data industry.

Watch now

Stay in touch

Sign up for news on Summit 2022 and beyond

Redgate will only contact you about PASS Data Community Summit and SQL Saturday, unless you separately request emails about Redgate.