Hash Join

  • To be a little nit picky, when creating a question that you need to select 4 of 5 checkboxes, it's probably more appropriate to reword the question and have the audience select the one RADIO button that does not meet the needs.

    For example, the question currently is written as: "Select 4 of these answers, which can potentially to reduce the frequency of hash bailouts." It should have been written as "Select which statement does not reduce the frequency of hash bailouts."

    Also, having an "All of the above" option when it clearly says to select 4 is not necessary. If someone felt that "All of the above" was the correct answer, what other three should they select?

  • Interesting topic on Hash Join and again a tricky question in that one could overlook the fact that a unique constraint already does exist in this particular scenario.

    Thanks.

  • Interesting question, and here is another link for reference: http://sqlmonitormetrics.red-gate.com/hash-warnings-in-last-hour/

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

Viewing 3 posts - 31 through 32 (of 32 total)

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