Deadlock

  • Jagadish Kumar Punnapu

    SSChasing Mays

    Points: 645

    Comments posted to this topic are about the item Deadlock

  • baabhu

    SSCertifiable

    Points: 6202

    Good Question !!!!!

  • Ron McCullough

    SSC Guru

    Points: 63877

    Good question - jogged my memory and by gosh I had not forgotten it.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • SQLRNNR

    SSC Guru

    Points: 281210

    winner winner chicken dinner.

    :w00t:

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Paul White

    SSC Guru

    Points: 150442

    Guessed from memory at 31 (-15 to +15) and got it wrong. Ah well.

  • Ian_McCann

    SSCertifiable

    Points: 5132

    Good question.

    I would have been happy to have gone with 3 , if it was an option.

  • Mark Fitzgerald-331224

    SSCrazy Eights

    Points: 8489

    Sorry to be pedantic on this but the answer to the question as written is 1. The DBA can only specify a single deadlock priority at a time. The question should be "While setting the Deadlock priority using numeric priority argument, in how many different levels could a DBA specify the Deadlock Priority for a given session?".

    Not that I dislike the question, just for clarity.

    Fitz

  • Koen Verbeeck

    SSC Guru

    Points: 258941

    Nice question, thanks!

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Koen Verbeeck

    SSC Guru

    Points: 258941

    Mark Fitzgerald-331224 (2/8/2012)


    Sorry to be pedantic on this but the answer to the question as written is 1. The DBA can only specify a single deadlock priority at a time. The question should be "While setting the Deadlock priority using numeric priority argument, in how many different levels could a DBA specify the Deadlock Priority for a given session?".

    Not that I dislike the question, just for clarity.

    Fitz

    1 is not one of the available answers ๐Ÿ™‚

    And it is clear that the person who wrote the question is not a native English speaker...

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • This was removed by the editor as SPAM

  • Stuart Davies

    SSCoach

    Points: 18874

    Good question - thanks

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a questionThere are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. โ€• Carl Sagan I would never join a club that would allow me as a member - Groucho Marx

  • Brigadur

    SSCrazy

    Points: 2097

    Thanks for the question, i will try to remember ... ๐Ÿ™‚

  • M&M

    SSC-Insane

    Points: 21679

    Thanks for the question

    M&M

  • Jagadish Kumar Punnapu

    SSChasing Mays

    Points: 645

    Thank you all for your responsesโ€ฆ ๐Ÿ™‚

  • Jagadish Kumar Punnapu

    SSChasing Mays

    Points: 645

    Mark Fitzgerald-331224 (2/8/2012)


    Sorry to be pedantic on this but the answer to the question as written is 1. The DBA can only specify a single deadlock priority at a time. The question should be "While setting the Deadlock priority using numeric priority argument, in how many different levels could a DBA specify the Deadlock Priority for a given session?".

    Not that I dislike the question, just for clarity.

    Fitz

    Thanks for your feedback Fitz... will consider it going forward...

Viewing 15 posts - 1 through 15 (of 30 total)

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