Erik, I read your old posts about RSCI friday at work for a reason. Got home and checked the youtube vids, and there you are explaining the topic as if I requested it. Your effort is much appreciated! I even like your jokes so I may not qualify as sane, but I will appreciate good work at any rate, thank you sooo much! :)
@@ErikDarlingData RCSI wasnt the immediate solution, will implement it though sp_BlitzLock helped me find the problem sp, that had functions as joins, replaced them with temp tables, no more locks Am a fan boy and bought your course, so consider me biased :) Thank you!
Hi Erik - I remember back in the days I used to confuse all these isolation levels with their names sounding so similar, but being essentially so different. Therefore eventually, for the second optimistic one, i.e. for the "SI" one, I came up with the "TLSI" alias (sort of like "Transaction Level Snapshot Isolation"). So, in my world, the two optimistic ones are simply RCSI and TLSI. Anyway - great stuff, thanks again for all your videos down here. And it was quite nice to meet you in person at PASS 2024 (I stopped by to say Hi and shake hands out there. :) )
3:50 I have it on good authority that the In-Memory OLTP implementation of MVCC is identical to Postgres', but is somehow not a problem. I don't recall the details.
Erik, I read your old posts about RSCI friday at work for a reason. Got home and checked the youtube vids, and there you are explaining the topic as if I requested it.
Your effort is much appreciated! I even like your jokes so I may not qualify as sane, but I will appreciate good work at any rate, thank you sooo much! :)
Glad you’re enjoying the content! I count anyone who uses RCSI as sane, so you may be safe.
@@ErikDarlingData RCSI wasnt the immediate solution, will implement it though
sp_BlitzLock helped me find the problem sp, that had functions as joins, replaced them with temp tables, no more locks
Am a fan boy and bought your course, so consider me biased :)
Thank you!
Aw, thanks for your support! Glad it all worked out.
Good explanation, I'm going to forward to the devs I work with.
Woohoo! Hope it gets somewhere.
Hi Erik - I remember back in the days I used to confuse all these isolation levels with their names sounding so similar, but being essentially so different. Therefore eventually, for the second optimistic one, i.e. for the "SI" one, I came up with the "TLSI" alias (sort of like "Transaction Level Snapshot Isolation").
So, in my world, the two optimistic ones are simply RCSI and TLSI.
Anyway - great stuff, thanks again for all your videos down here.
And it was quite nice to meet you in person at PASS 2024 (I stopped by to say Hi and shake hands out there. :) )
Good to see you too! Hope we can run into each other again.
this is great content. wish i didnt skip out on pass this year
You’ve learned your lesson for next year.
I know nothing about isolation level so I'm golden. 😊
You might be the safest one.
3:50 I have it on good authority that the In-Memory OLTP implementation of MVCC is identical to Postgres', but is somehow not a problem. I don't recall the details.
Sounds like it was important information then!