High Deadlock Priority

Question

High Deadlock Priority

Steve Jones - SSC Editor

SSC Guru

Points: 736172
More actions
November 13, 2023 at 12:00 am

#4318451

Comments posted to this topic are about the item High Deadlock Priority

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004323 More actions · Answer 1

I have to admit, I'm totally amazed about the number of people that participate on the QoD and on Polls on linked in.

I'm also amazed at the number of wrong answers. Why would anyone guess on a QoD like this one if they didn't have the hard knowledge with here or on the LinkedIn Polls?

Here, on the QoD, I can may see "guessing" because everyone knows that there will be an explanation and usually a link. It's an easy way to NOT developer any addition search skills.

For LinkedIn Polls, I have no clue why people bother because I've not yet seen a Poll Author that comes back with the correct answer, an explanation, or a link.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Michael L John One Orange Chip Points: 27054 More actions · Answer 2

Jeff Moden wrote:

I have to admit, I'm totally amazed about the number of people that participate on the QoD and on Polls on linked in.
I'm also amazed at the number of wrong answers. Why would anyone guess on a QoD like this one if they didn't have the hard knowledge with here or on the LinkedIn Polls?
Here, on the QoD, I can may see "guessing" because everyone knows that there will be an explanation and usually a link. It's an easy way to NOT developer any addition search skills.
For LinkedIn Polls, I have no clue why people bother because I've not yet seen a Poll Author that comes back with the correct answer, an explanation, or a link.

I get more of the QoD's wrong than I do right. I guess and then I go look up the answer if it's something I do not know.

Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/

Steve Jones - SSC Editor SSC Guru Points: 736172 More actions · Answer 3

That's really the point. I think some of these aren't things you'd know, but perhaps can guess. Would you think the low/high setting would be the extreme end or in the middle? It's an interesting exercise, plus you might have this in the back of your mind as you deal with deadlocks and decide to build a process that will die and retry.