December 11, 2014 at 9:31 pm
Comments posted to this topic are about the item Whats going on Query window?
Thanks,
Shiva N
Database Consultant
December 12, 2014 at 12:38 am
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).
December 12, 2014 at 12:45 am
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.
December 12, 2014 at 12:47 am
I got a lucky guess on this, Choose three from five, two are successfull, three are unsuccessfull
December 12, 2014 at 12:59 am
Nice question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 12, 2014 at 1:25 am
This was removed by the editor as SPAM
December 12, 2014 at 2:58 am
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
December 12, 2014 at 4:17 am
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.
December 12, 2014 at 4:27 am
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 😉
December 12, 2014 at 5:40 am
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
December 12, 2014 at 7:13 am
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/
December 12, 2014 at 7:18 am
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.
December 12, 2014 at 7:19 am
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. 😀
December 12, 2014 at 7:24 am
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.
December 12, 2014 at 7:52 am
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 22 total)
You must be logged in to reply to this topic. Login to reply