Query Hints

  • Steve,

    It is hard, and it's really hard when "making up" answers to not collide with something in BOL

    and may I add Technet and MSDN.

    A question for you Steve. Ever think of recreating a group / committee / review board to review submitted QODs, with the caveat that if there is a lot of response complaining / disagreement that a member of the review team be responsible for answering same?

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • Ever think of recreating a group / committee / review board to review submitted QODs, with the caveat that if there is a lot of response complaining / disagreement that a member of the review team be responsible for answering same?

    I know the question was for Steve but what would the point of that be? To reduce the load on Steve or to reduce the complaining? I think it would be difficult to accomplish the later what with so many differing sources of information and such a large and diverse community of people with varying languages and backgrounds.

    The discussions are usually entertaining and often insightful. But I can imagine it can be frustrating at times for the author of the question and perhaps intimidating enough to others that it discourages others from contributing to them.

  • The problem with the committee is the load and getting things reviewed. We've tried a few things over the year, but it hasn't worked well.

    We'll never stop the complaining, and that's one reason do most of the questions. I don't mind it so much, but it's taken me awhile to get there. Feel free to send me some with a note you don't want credit.

    And this wasn't much complaining compared to some I've written!:w00t:

  • You are doing a great job. I love this forum. You have managed to attract a lot of talented people who feel passionate about these topics.

  • Steve

    Feel free to send me some with a note you don't want credit.

    Been trying to work up a couple of more, but hey if I supply an incorrect / incomplete answer heck I will stand up and take the heat - no different than at work .. I goof I get chewed out. But thanks for the offer to be an anonymous contributor. I've already had the good luck to submit one of those where the ranting was justified and believe you me, it taught me a lesson.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • Cliff Jones

    but what would the point of that be? To reduce the load on Steve or to reduce the complaining?

    Both.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • Hi!

    I think that Join Hints and Table Hints are not Query Hints.

    So instead

    Which of the folowing are valid types of query hints in SQL Server 2008? (select all that apply)

    ,it should probably be:

    Which of the folowing are valid types of hints in SQL Server 2008? (select all that apply)

    Sorry for nitpicking 😀

    Best Regards,

    Chris Büttner

  • I am beginning to wonder about the wording of the questions and answers on this site. Some answers are so downright cheeky that I am forced to answer other questions with a cheeky notion. This question, in particular, was one in which I felt I had to be cheeky. BOL only showed 2 kinds of query hints: "query hints" and "table hints". Had I not been "trained" to be so cheeky by some of the other questions on this site, I would've included "join hints". However, since "join hints" was NOT on the BOL page for "query hints", it seems inappropriate to reference BOL and then tell me my answer was wrong, simply because I followed BOL.

    I strongly urge someone out there to perhaps set a cheekiness meter on the questions and answers.

    I mean, do we really want a professional site out there that asks the following question 1000 different ways:

    "How many eggs can a rooster lay if it eats twice as much as usual?"

    Right, roosters don't lay eggs. But, what the heck is this question, in 1000 different SQL-type permutations, helping anyone?

  • I'm not sure how you get 2 hints. The page listed, http://msdn.microsoft.com/en-us/library/ms187713.aspx, has 3 types of hints there. That's where the question came from. We didn't search every reference in BOL to hints.

    There's no intent to trick or be "cheeky," the intent is to make you aware of something about SQL. Phrasing a question that does that can be hard, and if you don't think so, try writing a few yourself. I don't mean to be difficult, but just to make you aware that it's not a simple thing.

  • Jdshabat refer to my post on the 2nd page of this forum:

    So I offer this challenge to you: WRITE AND SUBMIT A QUESTION OF THE DAY Frame it / word it so that there is not a single rant claiming the answer(s) false / misleading or otherwise tainted. Remember the questions should not be trivial, rather their main purpose is to teach us all about some aspect of SQL Server.

    You will surprised, if you meet the challenge you will have done a great deal of research and learned a great deal about the particular subject your question addresses.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • Well, now I have a weekend project.

  • Jdshabat

    Good luck I shall look forward to your question, with clear concise choices. Let me point out what I believe is the most important portion of any question and that is:

    the questions should not be trivial, rather their main purpose is to teach us all about some aspect of SQL Server.

    Have fun - and be careful once you post one published QOD it becomes addictive and you will want to post more of them.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • Looking forward to seeing one and thanks for participating.

  • I submitted a suggestion and I don't believe it's trivial. I caught a few of my DBA buddies off guard with it. And Steve, I truly appreciate what you do here. I have taught and created many tests over the years. I know how difficult it can be. By all means, consider any feedback from me as positive, no matter how it sounds, because I KEEP COMING BACK FOR MORE!

    I don't know how you access my suggestions, but I can see that I've submitted it.

    Yes, I am expecting a wave of criticism if it makes it to the site.

    But, that's ok, I worked for state government for 5 years, so puhleeeeeeze.

    I made taking abuse into a job skill.

    😉

Viewing 14 posts - 16 through 28 (of 28 total)

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