This is one of the best database sessions I have seen.Immensely in-depth analysis with lots of examples. I never knew the intricate details mostly the effect of index on concurrency. Additionally Brent is extremely engaging and makes the session indeed awesome.
I fully appreciate the things I'm learning from Brent. But this doubles as insane comedy. From 2:00 to 2:24 blocking is explained. And what follows is "The symptom of this is..." and I was thinking of what technicality might follow...but the next 6 words are amazing. I'm listening to this 20 times in a row and can't stop laughing.
@@BrentOzarUnlimited Can confirm here from The Netherlands... Been around since SS 6.5 as an application developer. A bit older and slightly grayer now, but still learning from your excellent "compelling to watch" videos. Thank you so much and good health to you!
Great ! I have been an Oracle DBA for two decades using Multi Version Read Consistency and was unhappy with statements / behaviours like "Readers Block Writers, Writers Block Readers" and "Microsoft automatically escalates locks".
like the video..................this is a keep..........................must know the two ways to overcome the blocks.....a) having enough indexes, and using the right Isolation for you app's....:) .....bye
In the video timeline at 22:40 the resource_type ="OBJECT" means the table but why are you telling it is clustered index as for resource type = "KEY" it is clustered index.