August 3, 2015 at 8:08 am
Alvin Ramard (8/3/2015)
Ed Wagner (8/3/2015)
Sean Lange (8/3/2015)
Again lots of complaining. Come on people get over it. The question of the day is intended to provoke some learning. Guess what, as humans we learn more from our mistakes. Same goes for the QOTD. When you get it wrong you tend to remember it.Yes this had a couple of options that might have been correct and we kind of had to guess. I got it wrong. Big deal.
For all of the complainers out there stating just how awful this question is please let us know when you are going post a QOTD so that we may nit pick your question to death.
I agree with you, but I can't resist, Sean. Here's my question:
2 + 2 = 4
Joe has 8 apples and his train is running 17 minutes late.
Bob wants to travel south for the weekend, but can't because his pet monkey is sick.
Calculate the mass of the sun. Show your work.
😛
Answer is 43
I got 42.
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
August 3, 2015 at 8:11 am
Alvin Ramard (8/3/2015)
Ed Wagner (8/3/2015)
Sean Lange (8/3/2015)
Again lots of complaining. Come on people get over it. The question of the day is intended to provoke some learning. Guess what, as humans we learn more from our mistakes. Same goes for the QOTD. When you get it wrong you tend to remember it.Yes this had a couple of options that might have been correct and we kind of had to guess. I got it wrong. Big deal.
For all of the complainers out there stating just how awful this question is please let us know when you are going post a QOTD so that we may nit pick your question to death.
I agree with you, but I can't resist, Sean. Here's my question:
2 + 2 = 4
Joe has 8 apples and his train is running 17 minutes late.
Bob wants to travel south for the weekend, but can't because his pet monkey is sick.
Calculate the mass of the sun. Show your work.
😛
Answer is 43
I disagree. The answer is 42.
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/
August 3, 2015 at 8:29 am
oops, typo. Should have said 42
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 3, 2015 at 9:35 am
The formula for should be 42/purple but remember to carry the 2 🙂
There are no facts, only interpretations.
Friedrich Nietzsche
August 3, 2015 at 9:59 am
Alvin Ramard (8/3/2015)
Ed Wagner (8/3/2015)
Sean Lange (8/3/2015)
Again lots of complaining. Come on people get over it. The question of the day is intended to provoke some learning. Guess what, as humans we learn more from our mistakes. Same goes for the QOTD. When you get it wrong you tend to remember it.Yes this had a couple of options that might have been correct and we kind of had to guess. I got it wrong. Big deal.
For all of the complainers out there stating just how awful this question is please let us know when you are going post a QOTD so that we may nit pick your question to death.
I agree with you, but I can't resist, Sean. Here's my question:
2 + 2 = 4
Joe has 8 apples and his train is running 17 minutes late.
Bob wants to travel south for the weekend, but can't because his pet monkey is sick.
Calculate the mass of the sun. Show your work.
😛
Answer is 42
Edit: Corrected typo. Originally said 43 but correct answer is 42
Winner Winner Chicken Dinner
Winner Winner Chicken Dinner
(had to say it twice because the correct answer is 42!!)
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
August 3, 2015 at 10:25 am
I wish you all a good afternoon.
Answer Query 2 is incorrect because for ADD FILE it is required to enter File option FILENAME.
See syntax checking Query 2: Msg 1036, Level 15, State 1, Line 10
File option FILENAME is required in this CREATE/ALTER DATABASE statement.
Answer Query 3 is incorrect with specification OLDNAME. Correctly be NAME.
J.V.
August 3, 2015 at 11:48 am
I agree. Query 3 is the MODIFY FILE while Query 2 is ADD FILE:
-- Query 1
ALTER DATABASE AdventureWorks2012
ADD FILE (NAME=ADW2012 REPLACES Adventureworks2012_data)
[highlight=#ffff11]
-- query 2
ALTER DATABASE AdventureWorks2012
ADD FILE (NAME=AdventureWorks2012_data, NEWNAME=AWD2012 );
[/highlight]
[highlight=#ffff11]
-- query 3
ALTER DATABASE AdventureWorks2012
MODIFY FILE (OLDNAME=AdventureWorks2012_data, Newname= AWD2012);
[/highlight]
-- query 4
ALTER DATABASE AdventureWorks2012
ADD FILE (NEWNAME=AWD2012, OLDNAME=AdventureWorks2012_data );
August 3, 2015 at 5:49 pm
According to your option list, the 'Modify File' is in Query 3, not 2. So the correct answer is 3.
MCSE Data Platform; BI
MCITP Database Developer; BI
August 4, 2015 at 2:54 am
Almost got it right...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 4, 2015 at 10:02 am
Bobby Russell (8/3/2015)
The correct answer for today is incorrect. Steve must be hung over from the weekend. 😉
LOL, that's funny. Maybe one in the past. This question went in a few weeks ago.
August 4, 2015 at 10:03 am
Points awarded back and question corrected. My apologies for the error.
August 4, 2015 at 10:04 am
And as a side note, I didn't try this from memory, or fail to test it. I changed the names of my logical files on an instance here.
However. Where things break down, and usually cause issues is when I try to create the wrong answers. I can't test those, since they don't compile. I guess I can test those, but her I was trying to create three alternatives of answers, and ended up editing the wrong one.
August 4, 2015 at 5:53 pm
Ed Wagner (8/3/2015)
I agree with you, but I can't resist, Sean. Here's my question:2 + 2 = 4
Joe has 8 apples and his train is running 17 minutes late.
Bob wants to travel south for the weekend, but can't because his pet monkey is sick.
Calculate the mass of the sun. Show your work.
😛
O think there's too much disconnect in that after all, Steve's error did leave some connection between the question and possible answers. Perhaps it was just a simple typing erros - - after all, anyone could render a 6 letter word as just 3 letters (none of which occur in the original word), it can be caused by just a little of difficulty in getting the fingers to do the right things. I often find myself doing incorrect things like that when I've failed to imbibe sufficient alcolol to defeat the arthritis in my fingers (or is it when I haven't - I can't remember) 😀 .
Tom
August 5, 2015 at 2:04 pm
Steve Jones - SSC Editor (8/4/2015)
And as a side note, I didn't try this from memory, or fail to test it. I changed the names of my logical files on an instance here.However. Where things break down, and usually cause issues is when I try to create the wrong answers. I can't test those, since they don't compile. I guess I can test those, but her I was trying to create three alternatives of answers, and ended up editing the wrong one.
Steve, I am shocked, truly shocked, that you are not perfect. 😛
Viewing 14 posts - 31 through 43 (of 43 total)
You must be logged in to reply to this topic. Login to reply