One of my greatest pains in life is the comment from the developer "No I am 100% certain that my code is not causing any blocking because I put NOLOCK hints on all my SELECTs. So it must be something else."
Very few people are interested in learning these mechanics, yet will argue with you armed with all of their misconceptions. It's a sad state of affairs.
Awesome Erik! Updated my tips repo 🤫
Darling for President!
Vote early, vote often.
I am going to add this to my toolkit. Thanks!
Your developers will love you for this 😃
Shorts from Erik. O tempora, o mores!
I never thought I’d see the day.
One of my greatest pains in life is the comment from the developer "No I am 100% certain that my code is not causing any blocking because I put NOLOCK hints on all my SELECTs. So it must be something else."
Explaining why that is wrong is always a pain. You have to get in to what locks NOLOCK takes and what it respects.
Very few people are interested in learning these mechanics, yet will argue with you armed with all of their misconceptions. It's a sad state of affairs.
So covert! Didn't think of you as that sneaky 🤣🤣
I like surprises.
I like it!
And I like you!
i do like devious and mischievous things...
There are entire club basements dedicated to that.