Post reply

Deadlock

  • February 7, 2012 at 8:46 pm

    #255276

    Comments posted to this topic are about the item Deadlock

  • February 7, 2012 at 8:48 pm

    #1444269

    Good Question !!!!!

  • February 7, 2012 at 8:48 pm

    #1444270

    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]

  • February 7, 2012 at 9:59 pm

    #1444276

    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

  • February 7, 2012 at 10:56 pm

    #1444284

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

    Paul White
    SQLPerformance.com
    SQLkiwi blog
    @SQL_Kiwi

  • February 8, 2012 at 12:14 am

    #1444301

    Good question.

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

  • February 8, 2012 at 12:25 am

    #1444304

    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

  • February 8, 2012 at 12:27 am

    #1444305

    Nice question, thanks!

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

  • February 8, 2012 at 12:29 am

    #1444306

    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

  • February 8, 2012 at 12:29 am

    This was removed by the editor as SPAM

  • February 8, 2012 at 12:36 am

    #1444310

    Good question - thanks

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
    There 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

  • February 8, 2012 at 12:43 am

    #1444312

    Thanks for the question, i will try to remember ... 🙂

  • February 8, 2012 at 3:19 am

    #1444377

    Thanks for the question

    M&M

  • February 8, 2012 at 3:45 am

    #1444389

    Thank you all for your responses… 🙂

  • February 8, 2012 at 3:53 am

    #1444392

    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 29 total)

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