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
356
83
4 weeks ago 00:12:05 1
ZenBusiness Review 2024: What Makes It Stand Out?
4 weeks ago 00:20:33 1
Movie “Wicked” Sign of the End Time
4 weeks ago 00:03:04 1
Bach, Organ Sonata No. 4 in E minor (BWV 528) 3. Un poco Allegro.
4 weeks ago 00:00:32 1
…but the people are retarded
4 weeks ago 00:02:36 5
Jingle Bells | Christmas Song | Super Simple Songs
4 weeks ago 00:03:02 1
Milk & Cookies | Holiday Song for Kids | Rhymington Square
4 weeks ago 00:02:36 1
Five Little Elves | Christmas Song For Kids | Super Simple Songs
4 weeks ago 00:12:48 1
The Brand New STIHL MS400.1! WHY is this CHAINSAW different?
4 weeks ago 00:08:10 1
AI Agents Will Create MILLIONAIRES in 2025 – Are You Ready
4 weeks ago 00:04:49 1
Play To Earn🔥This New Play to Earn Game is About to Make a Lot of People RICH
4 weeks ago 00:03:02 1
SPX Options Trading : Strategies for Big Gains!
1 month ago 00:00:35 1
This Takodachi Bites Ina
1 month ago 00:08:50 1
Just Dance 2025 Edition - The Making Of
1 month ago 00:03:31 1
The Hobbies Song for Kids | What Do You Like to Do? | Fun Kids English
1 month ago 00:11:11 1
Archangels Healing Your Aura @432Hz In Just 11 Minutes With Delta Waves
1 month ago 00:02:50 1
We Are Number One but it contains spoilers from Madoka Magica Concept Movie (and Rebellion)
1 month ago 00:04:14 1
The Hunter - Bloodborne (4K UHD 2024)
1 month ago 00:26:26 1
LEGO Horizon Adventures PS5 Pro Gameplay - Thunderjaw Boss Fight