Whats going on Query window?

  • Shiva N

    Hall of Fame

    Points: 3125

    Comments posted to this topic are about the item Whats going on Query window?

    Thanks,
    Shiva N
    Database Consultant

  • Heals

    SSCrazy

    Points: 2234

    Got this one right, but only after some googling and a bit of elimination based on what I already knew - I had to take an educated guess for the third option.

    However, the question seems to be worded incorrectly - if you run this code against SQL 2008R2 you only get two messages come back (At least I did when I checked my instance).

  • sqlsniper

    Right there with Babe

    Points: 734

    The question covers some interesting aspects of transactions and serversettings.

    On the other hand, the answers are formulated in a way in which you can glean the right answer from the context.

    As you have to select 3 answers of the 5. Two of them are output when all statements are executed correctly, while three of them cover aspects when things go wrong.

  • Ian_McCann

    SSCertifiable

    Points: 5132

    I got a lucky guess on this, Choose three from five, two are successfull, three are unsuccessfull

  • Koen Verbeeck

    SSC Guru

    Points: 258965

    Nice question, thanks.

    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

  • Andre Guerreiro

    SSCertifiable

    Points: 7319

    Thanks for the question.

    I didn't get it right but then I'm not a human SQL parser. :w00t:

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

  • Ed Wagner

    SSC Guru

    Points: 286979

    Stewart "Arturius" Campbell (12/12/2014)


    Heals (12/12/2014)


    However, the question seems to be worded incorrectly - if you run this code against SQL 2008R2 you only get two messages come back (At least I did when I checked my instance).

    +1

    at least I learned something today - read the question carefully before answering, and then only after the first cup of coffee...:-D

    Agreed. The statement of fact is not output. Still, a good question that makes a good point.

  • Toreador

    SSChampion

    Points: 11252

    Got this wrong, as it asked what output we'd get. I figured that "You can't use transactions on sp_configure" was an unlikely looking error message so ruled it out.

    Turns out I was right and wrong at the same time 😉

  • SQLRNNR

    SSC Guru

    Points: 281243

    Ed Wagner (12/12/2014)


    Stewart "Arturius" Campbell (12/12/2014)


    Heals (12/12/2014)


    However, the question seems to be worded incorrectly - if you run this code against SQL 2008R2 you only get two messages come back (At least I did when I checked my instance).

    +1

    at least I learned something today - read the question carefully before answering, and then only after the first cup of coffee...:-D

    Agreed. The statement of fact is not output. Still, a good question that makes a good point.

    +1

    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

  • Sean Lange

    SSC Guru

    Points: 286531

    Interesting question. It seems it was poorly worded since one of the correct answers is a statement of fact but the question ask what is the output. Also, the link for documentation is a pretty bad choice since it is the sql 2000 version. There is no reference at all to sp_configure. Great topic but the execution missed the mark for me.

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

  • Raghavendra Mudugal

    SSChampion

    Points: 10658

    Thank you for the post, really good one. I had experience on this so it became to me to pick the choices.

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • Bobby Russell

    SSCrazy

    Points: 2641

    Got this one right! Why you ask? Because I gave the wrong answer! There are only two correct answers on here and if you answer this question correctly as it is asked, you will be wrong. Someone really should administer the QODs. 😀

  • Ed Wagner

    SSC Guru

    Points: 286979

    Bobby Russell (12/12/2014)


    Got this one right! Why you ask? Because I gave the wrong answer! There are only two correct answers on here and if you answer this question correctly as it is asked, you will be wrong. Someone really should administer the QODs. 😀

    I think with the caliber of people looking at the QOTD, we pretty-much police it ourselves. My hope is that people will learn from the constructive criticism and improve. You have to keep in mind who uses this site - we're bound to catch anything that's wrong or misleading in any post. The good part is that calling it out is usually done constructively and we correct each other.

  • Nevyn

    SSChampion

    Points: 14210

    However, the question seems to be worded incorrectly - if you run this code against SQL 2008R2 you only get two messages come back (At least I did when I checked my instance).

    +1

    The question helped me get knowledge I didn't already have, and I fully admit I was guessing.

    But the question asked for which output you get back, and one of the 'correct' answers is not an output but rather a factual statement

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

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