Everything You Know About Isolation Levels Is Wrong
The PASS Data Summit session lineup has been announced! And, you know, since me and Kendra are double-teaming two days of precons Nov 4-8 in Seattle, I’ve got a regular session too!
Everything You Know About Isolation Levels Is Wrong
You’ve been told that NOLOCK hints are bad, so you look at all the queries your developers write and hang your head in shame.
A NOLOCK hint here, a NOLOCK there, a NOLOCK hint seemingly everywhere. Like termites, eating at the foundation of your well-being.
But in the real world, how are you supposed to remove those all those yucky hints without blocking and deadlocking causing huge problems?
I’m Erik Darling, a world class NOLOCK hint removal expert, and in this demo-heavy session, I’ll change your mind about every isolation level. You’re going to learn why:
- Read Committed is nearly as weak as Read Uncommitted
- Optimistic isolation levels aren’t incorrect-result factories
- Repeatable Read isn’t what it sounds like
- Serializable isn’t the enemy of concurrency
- You don’t need to worry about tempdb’s version store
- No isolation level is perfect for every workload
At the end, you’ll have the confidence and knowledge to start turning on optimistic isolation levels and stop hanging NOLOCK hints all over your queries like Christmas tree ornaments.
Session Prerequisites: Basic understanding of locking and blocking problems, some familiarity with isolation levels.
Get A Deal On Ticket Prices
If you want to get a deal on registration — and you should hurry up and do that because birds of earliness prices expire on July 9th — head over here.
When you’re registering, use the discount code DARLINGE24Â for $150 off the regular price for the three regular session days, Wednesday – Friday.
While you’re there, don’t forget to sign up for me and Kendra’s precon days.
Because I’m teaching on my birthday, and if you don’t come we are NOT FRIENDS ANYMORE!
Thanks for reading, and see you in Seattle!
Going Further
If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount to my blog readers if you click from here. I’m also available for consulting if you just don’t have time for that, and need to solve database performance problems quickly. You can also get a quick, low cost health check with no phone time required.