Make Your Own SQL Server Queries Go Faster by John Sterrett
Have you ever developed slowly running queries and wondered how to make your own SQL Server queries go faster? I know I did. It is how I stumbled into my career in performance tuning. In this session, you will learn some T-SQL performance tuning tips that can be used in the office immediately. You will learn how to identify top offender queries, be able to benchmark queries. Finally, we will cover some coding patterns that are developer friendly but are not SQL Server database engine friendly and show you how to rewrite them so they can run faster.
John Sterrett is a Microsoft Data Platform MVP, MCSE: Data Platform, Principal Consultant and the Founder of Procure SQL LLC. Previously, he was a Sr. Database Admin Advisor for Dell, directly responsible for several mission-critical databases behind . John has presented at many community events, including PASS Summit, SQLRally, 24 Hours of PASS, SQLSaturdays, PASS Chapters, and Virtual Chapter meetings. John is a leader and founder of the HADR Virtual Chapter.
Get full session notes at:
1 view
355
83
6 days ago 00:12:05 1
ZenBusiness Review 2024: What Makes It Stand Out?
6 days ago 00:20:33 1
Movie “Wicked” Sign of the End Time
1 week ago 00:03:04 1
Bach, Organ Sonata No. 4 in E minor (BWV 528) 3. Un poco Allegro.
1 week ago 00:00:32 1
…but the people are retarded
1 week ago 00:02:36 5
Jingle Bells | Christmas Song | Super Simple Songs
1 week ago 00:03:02 1
Milk & Cookies | Holiday Song for Kids | Rhymington Square
1 week ago 00:02:36 1
Five Little Elves | Christmas Song For Kids | Super Simple Songs
1 week ago 00:12:48 1
The Brand New STIHL MS400.1! WHY is this CHAINSAW different?
1 week ago 00:08:10 1
AI Agents Will Create MILLIONAIRES in 2025 – Are You Ready
1 week ago 00:04:49 1
Play To Earn🔥This New Play to Earn Game is About to Make a Lot of People RICH
1 week ago 00:03:02 1
SPX Options Trading : Strategies for Big Gains!
2 weeks ago 00:00:35 1
This Takodachi Bites Ina
2 weeks ago 00:08:50 1
Just Dance 2025 Edition - The Making Of
2 weeks ago 00:03:31 1
The Hobbies Song for Kids | What Do You Like to Do? | Fun Kids English
2 weeks ago 00:11:11 1
Archangels Healing Your Aura @432Hz In Just 11 Minutes With Delta Waves
2 weeks ago 00:02:50 1
We Are Number One but it contains spoilers from Madoka Magica Concept Movie (and Rebellion)
2 weeks ago 00:04:14 1
The Hunter - Bloodborne (4K UHD 2024)
2 weeks ago 00:26:26 1
LEGO Horizon Adventures PS5 Pro Gameplay - Thunderjaw Boss Fight