Hash Join

• cengland0

  SSCertifiable

  Points: 6102

  More actions

  February 21, 2012 at 2:32 am

  #1449530

  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?

• zymos

  SSCommitted

  Points: 1960

  More actions

  February 21, 2012 at 2:57 pm

  #1450004

  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.

• Hany Helmy

  SSChampion

  Points: 13921

  More actions

  January 5, 2015 at 11:35 pm

  #1767958

  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