Dba: Why would you ever mix the SNAPSHOT isolation level with an UPDLOCK?

Channel:
Peter Schneider
Subscribers:
4,320
Published on ● Video Link: https://www.youtube.com/watch?v=KuAlAFu_P9M


Duration: 0:00
5 views
0

Why would you ever mix the SNAPSHOT isolation level with an UPDLOCK?
I hope you found a solution that worked for you :)
The Content is licensed under (https://meta.stackexchange.com/help/licensing) CC BY-SA.
Attention! This video does always use the same license as the source!
Thanks to all those great people for their contributions!

(dba.stackexchange.com/users/277982/j-mini)J. Mini
(dba.stackexchange.com/users/1192/paul-white)Paul White
(dba.stackexchange.com/users/44434/dan-guzman)Dan Guzman
A special thanks goes out to the (dba.stackexchange.com/questions/346491/why-would-you-ever-mix-the-snapshot-isolation-level-with-an-updlock)Stackexchange community

I wish you all a wonderful day! Stay safe :)
If anything is off, please write me at peter D.O.T schneider A.T ois42.de

snapshot-isolation isolation-level sql-server locking sql-server-2022



Other Videos By Peter Schneider


2025-05-18Ux: How best to combat right hand column blindness
2025-05-18Ux: What's the most common aspect ratio in terms of web design? closed
2025-05-18Ux: What's the best terminology for switching from a mobile site to the "full" website?
2025-05-18Ux: Does Android app need back button?
2025-05-18Check at compile time that a function call triggers a static_assert(false)
2025-05-18Unix: Extracting paragraphs with awk
2025-05-18What creates security around passkey creation that makes it stronger than a password?
2025-05-18Ux: Typical Android app behavior for deleting data from a list
2025-05-18Ux: How to handle creating new account with email address that is unverified on another account?
2025-05-18Ux: How important is the ability to change the color theme on a desktop application?
2025-05-17Dba: Why would you ever mix the SNAPSHOT isolation level with an UPDLOCK?
2025-05-16Dba: Is TiDB compatible with WordPress, anyone running a large WP site with it?
2025-05-16Dba: MySQL: Updating with multiple foreign keys affecting same column
2025-05-16Retrocomputing: Bank-switching a CoCo 2 to "All RAM" and back?
2025-05-16Is implicit conversion to std::optional guaranteed to use move constructor?
2025-05-16Dba: How I can proxy my connection in order to translate the host that I need to connect upon db?
2025-05-16Electronics: Two batteries in parallel, but one has a current shunt on its ground lead?
2025-05-16Tex: Understanding SizeFeatures of fontspec
2025-05-16Ethereum: Is there any way to reuse schema.graphql files between subgraphs on The Graph?
2025-05-16Tex: .initial:n leads to an error when after .inherit:n?
2025-05-16Electronics: Identifying a module containing MAX3232 and PIC16F690