August 2021 - Make Your SQL Server Queries Go Faster by John Sterrett (@JohnSterrett)
Abstract:
Have you ever developed slowly running queries and wondered how to make your own SQL Server queries go faster? In this session, you will learn some T-SQL performance tuning tips that can be used on Monday back at the office. You will learn how to identify top offender queries, be able to benchmark queries. Finally we will cover 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.
Prerequisites: Experience building T-SQL Queries and the curiosity to learn how to tune your own queries.
About John
John Sterrett is a MCSE: Data Platform, Principal Consultant, and the Founder of Procure SQL LLC. John has experience presenting at community events, including Microsoft Ignite, PASS Member Summit, SQLRally, 24 Hours of PASS, SQL Saturdays, PASS Chapters, and Virtual Chapter meetings. John is a leader of the Austin SQL Server User Group and is the founder of the HADR Virtual Chapter. John's community activities can be found at https://johnsterrett.com/community/
-
3:25
Melodies of Our Plants and Water Chime Crystals
3 years agoLiven Up St John Wort August 2021
31 -
6:56
StreamDoctor
3 years agoGREAT APP TO MAKE YOUR FIRESTICK FASTER! - 2023 GUIDE
40 -
1:03:34
Data.SQL.Saturday.LA
3 years ago2021 Data.SQL.Saturday.LA presents: Lock Picking your SQL Server
38 -
1:29:28
Ben Shapiro
6 hours agoHow Wokeness Ruined UCLA
62K27 -
LIVE
Right Side Broadcasting Network
1 day agoLIVE: Trump Participates in 11th Hour Faith Leaders Meeting in Concord, NC - 10/21/24
5,270 watching -
2:31:01
The Quartering
8 hours agoTim Pool Studio Sabotaged? Trump Surging In Polls, Kamala In Hiding After McDonalds Disaster & Diddy
87.8K76 -
1:04:30
Quite Frankly
13 hours ago[Book Club] The Masque of The Red Death, by Edgar Allan Poe
36.4K1 -
UPCOMING
The Anthony Rogers Show
9 hours agoEpisode 344 - Is Obama's Birth Certificate Even Real?
41.2K5 -
1:09:46
We Like Shooting
16 hours ago $4.92 earnedDouble Tap 380 (Gun Podcast)
30.3K5 -
1:01:00
The StoneZONE with Roger Stone
5 hours agoWhy Did Kamala Persecute this Black Mom and Her Daughter? w/ Cheree Peoples | The StoneZONE
49.4K14