2021 Data.SQL.Saturday.LA presents: Every Millisecond Counts
Event organizer:
https://linktr.ee/sqlsatla
Session Room:
VMware (@vmware)
Session Speakers:
Jared Poche (sqljared)
Session Hosts:
Steve Rezhener (@SteveRezhener)
Session Abstract:
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.
Session Materials:
TBD
Session Feedback:
https://forms.office.com/r/p4JGycv9Wu
-
52:03
Data.SQL.Saturday.LA
3 years ago2021 Data.SQL.Saturday.LA presents: Every Millisecond Counts
16 -
1:11:36
Data.SQL.Saturday.LA
3 years ago2021 Data.SQL.Saturday.LA presents: In-memory OLTP Design Principles
48 -
1:08:23
Data.SQL.Saturday.LA
3 years ago2021 Data.SQL.Saturday.LA presents: PowerShell and DBATools
52 -
59:24
Data.SQL.Saturday.LA
3 years ago2021 Data.SQL.Saturday.LA presents: The Curated Data Platform
16 -
1:04:07
Data.SQL.Saturday.LA
3 years ago2021 Data.SQL.Saturday.LA presents: Advanced data types – JSON
40 -
1:03:34
Data.SQL.Saturday.LA
3 years ago2021 Data.SQL.Saturday.LA presents: Lock Picking your SQL Server
44 -
59:32
Data.SQL.Saturday.LA
3 years ago2021 Data.SQL.Saturday.LA presents: Lightning-fast processing in a SQL Server
17 -
5:53
SLS - Street League Skateboarding
5 days agoBraden Hoban’s San Diego Roots & Hometown Win | Kona Big Wave “Beyond The Ride” Part 2
75.7K12 -
6:03:57
TheBedBug
12 hours ago🔴 LIVE: EPIC CROSSOVER - PATH OF EXILE 2 x MARVEL RIVALS
90.3K5 -
1:12:45
The Quartering
10 hours agoTerror In New Orleans, Attacker Unmasked, Tesla BLOWS UP At Trump Tower! Are We Under Attack?
145K250