March 23, 2011 at 10:33 pm
Comments posted to this topic are about the item SQL Server Job Steps
March 23, 2011 at 10:33 pm
Thanks for the question!
March 24, 2011 at 1:32 am
A bit easy, but still 40% (at the moment) got it wrong :blink:
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 24, 2011 at 2:05 am
Thanks for the question. Easy one. 🙂
M&M
March 24, 2011 at 2:28 am
They got it wrong because they are using 2005 & the question doesn't specify the version and I suspect most businesses are still using 2005 for production systems.
March 24, 2011 at 2:41 am
A good question. It would have been a great question if the author had not forgotten to specify the version - Powershell is not supported in SQL Server 2005, so that might cause some incorrect replies.
It was a nice touch to indicate the number of answers that has to be checked. Though this makes it easier as well - since there were only five options, I knew I had the correct answer as soon as I identified the one incorrect option. Would it not have been simpler to ask us to check the option that is NOT a job step and require only a single answer?
I hope to see more questions from this contributor.
March 24, 2011 at 2:57 am
Good question and not too difficult. I did my certs in 2008 and so my natural inclination was to answer the question with that version in mind 😀
March 24, 2011 at 3:30 am
Hugo Kornelis (3/24/2011)
A good question. It would have been a great question if the author had not forgotten to specify the version - Powershell is not supported in SQL Server 2005, so that might cause some incorrect replies.It was a nice touch to indicate the number of answers that has to be checked. Though this makes it easier as well - since there were only five options, I knew I had the correct answer as soon as I identified the one incorrect option. Would it not have been simpler to ask us to check the option that is NOT a job step and require only a single answer?
I hope to see more questions from this contributor.
Ah, that explains it. If it didn't say "Select Four," I would have gotten the question wrong because I frequently create Steps in Jobs have never seen "Powershell" or "Reporting Services Report Subscriptions" options so I would have only selected 3. I use 2005 and had to look this one up before answering to find the proper 4th option.
March 24, 2011 at 5:36 am
Nice and easy one..Thanks for the question.
March 24, 2011 at 6:27 am
As others have pointed out, the "correct" answer is wrong. Powershell is NOT an option in 2005. I got it right for the wrong reason: I guessed that Powershell integration was more likely in in 2008 than an RS subscription.
These kinds of versioning problems with QoD are common enough and easily prevented: couldn't SSC require all submitters to specify which versions they have tested their question on?
Rich
March 24, 2011 at 9:08 am
rmechaber (3/24/2011)
As others have pointed out, the "correct" answer is wrong. Powershell is NOT an option in 2005. I got it right for the wrong reason: I guessed that Powershell integration was more likely in in 2008 than an RS subscription.These kinds of versioning problems with QoD are common enough and easily prevented: couldn't SSC require all submitters to specify which versions they have tested their question on?
Rich
By that same logic it is also correct if the version is 2008. With no version specified it could be right OR wrong. You feel it is wrong because you are on 2005 and the author feels it is right because he is on 2008.
I would definitely say that the QOTD lived up to its expectations in that it made you think and learn something. Version challenges will always be an issue with QOTD because we get cool new features with each new version and there are always going to be people that are not on the most current version.
_______________________________________________________________
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/
March 24, 2011 at 9:43 am
Sean Lange (3/24/2011)
rmechaber (3/24/2011)
As others have pointed out, the "correct" answer is wrong. Powershell is NOT an option in 2005. I got it right for the wrong reason: I guessed that Powershell integration was more likely in in 2008 than an RS subscription.These kinds of versioning problems with QoD are common enough and easily prevented: couldn't SSC require all submitters to specify which versions they have tested their question on?
Rich
By that same logic it is also correct if the version is 2008. With no version specified it could be right OR wrong. You feel it is wrong because you are on 2005 and the author feels it is right because he is on 2008.
I would definitely say that the QOTD lived up to its expectations in that it made you think and learn something. Version challenges will always be an issue with QOTD because we get cool new features with each new version and there are always going to be people that are not on the most current version.
Sean, I will respectfully disagree: if it's not always true, then it's false.
There is no reason for these ambiguities to exist and persist in QoD, when it's easy enough for submitters to check the questions beforehand, either on their own systems or, if necessary to cover other versions, someone else's. At the very least, if the question were only marked as "Tested on SQL Server 2008 R2," we'd know that much.
I don't care about getting points or the number of right answers I get. I care about misinformation propagated as truth. It is misleading and incorrect to identify a "correct" answer without qualifying the circumstances under which the answer is, in fact, correct.
Rich
March 24, 2011 at 10:04 am
rmechaber (3/24/2011)
Sean Lange (3/24/2011)
rmechaber (3/24/2011)
As others have pointed out, the "correct" answer is wrong. Powershell is NOT an option in 2005. I got it right for the wrong reason: I guessed that Powershell integration was more likely in in 2008 than an RS subscription.These kinds of versioning problems with QoD are common enough and easily prevented: couldn't SSC require all submitters to specify which versions they have tested their question on?
Rich
By that same logic it is also correct if the version is 2008. With no version specified it could be right OR wrong. You feel it is wrong because you are on 2005 and the author feels it is right because he is on 2008.
I would definitely say that the QOTD lived up to its expectations in that it made you think and learn something. Version challenges will always be an issue with QOTD because we get cool new features with each new version and there are always going to be people that are not on the most current version.
Sean, I will respectfully disagree: if it's not always true, then it's false.
There is no reason for these ambiguities to exist and persist in QoD, when it's easy enough for submitters to check the questions beforehand, either on their own systems or, if necessary to cover other versions, someone else's. At the very least, if the question were only marked as "Tested on SQL Server 2008 R2," we'd know that much.
I don't care about getting points or the number of right answers I get. I care about misinformation propagated as truth. It is misleading and incorrect to identify a "correct" answer without qualifying the circumstances under which the answer is, in fact, correct.
Rich
This type of issue has sparked some heated exchanges in recent QoDs. I second the request that all questions contain something like this "Tested on default install SQL Server XXXX, language: us_english".
Kevin
March 24, 2011 at 10:23 am
I respectfully agree with the previous requests to identify the version/settings specific to the question and answer. 🙂
March 24, 2011 at 10:34 am
kevin.l.williams (3/24/2011)
rmechaber (3/24/2011)
Sean Lange (3/24/2011)
rmechaber (3/24/2011)
As others have pointed out, the "correct" answer is wrong. Powershell is NOT an option in 2005. I got it right for the wrong reason: I guessed that Powershell integration was more likely in in 2008 than an RS subscription.These kinds of versioning problems with QoD are common enough and easily prevented: couldn't SSC require all submitters to specify which versions they have tested their question on?
Rich
By that same logic it is also correct if the version is 2008. With no version specified it could be right OR wrong. You feel it is wrong because you are on 2005 and the author feels it is right because he is on 2008.
I would definitely say that the QOTD lived up to its expectations in that it made you think and learn something. Version challenges will always be an issue with QOTD because we get cool new features with each new version and there are always going to be people that are not on the most current version.
Sean, I will respectfully disagree: if it's not always true, then it's false.
There is no reason for these ambiguities to exist and persist in QoD, when it's easy enough for submitters to check the questions beforehand, either on their own systems or, if necessary to cover other versions, someone else's. At the very least, if the question were only marked as "Tested on SQL Server 2008 R2," we'd know that much.
I don't care about getting points or the number of right answers I get. I care about misinformation propagated as truth. It is misleading and incorrect to identify a "correct" answer without qualifying the circumstances under which the answer is, in fact, correct.
Rich
This type of issue has sparked some heated exchanges in recent QoDs. I second the request that all questions contain something like this "Tested on default install SQL Server XXXX, language: us_english".
Kevin
I absolutely agree that version should be mentioned with every question. One of the biggest challenges is that we don't all have all the versions available to us. The version argument will continue until the end of time and as you suggested the best (and probably only) way to avoid it is to have the version number(s) as part of the question.
_______________________________________________________________
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/
Viewing 15 posts - 1 through 15 (of 29 total)
You must be logged in to reply to this topic. Login to reply