• SanDroid (10/27/2010)


    da-zero (10/27/2010)


    All I am reading is: easy question = good, difficult question = bad 😉

    I can tell by your reading and writing level you might be the moderator checking the questions before posting them.

    Suggestion, actually try to execute the code and check for errors. This is the first QOTD I have looked at this month that didn't have any.

    Is that easy or difficult for you to understand? 😎

    The only people who review the questions are the question author (Abhijit for this question), and Steve Jones. And Steve often lacks the time to properly check the questions. So your assessment of da-zero is wrong.

    I do not agree with the comment da-zero made to your post. But I also disagree with your enthousiasm about this question. I do agree partly with the second sentence you wrote ("It was code correct, the question was clear and had no typo's, and the author clearly understood the concept his question was testing"), though the code was definitely not safe in non-US environments.

    But I totally disagree with your final statement ("That along with the fact they they were complex questions with complex SQL Server features and statements made them horible"). These questions should provide a learning opportunity, and that will hardly happen with questions as simple as this one. I expect the QotD to be about complex and/or little-known features.

    (And yes, I also expect them to be error-free -which unfortunately happens less often than I would like).


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/