The Right Kind Of Join

  • Nice. I had to work for this one - learned quite a bit in the process. Thanks!

    -Ki

  • nice question!


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!
  • Learned something new again today, thanks.

    http://brittcluff.blogspot.com/

  • I was able to look this up and find the right answer but I'd be lying if I said that I understood what is going on here. Is there an article that explains the join hints? If not, perhaps that's a good area for a future article. MSDN wasn't particularly helpful to me on this. I suspect that they expect me to have some base level of knowledge that I'm lacking. :crying:

  • Good Question on Join Hints. 🙂

  • Nice question. I look forward to more questions related to join hints.

  • Really interesting question, thanks

  • thanks - great question 🙂

  • Thanks for the question!

  • Ernie Schlangen (8/24/2011)


    I was able to look this up and find the right answer but I'd be lying if I said that I understood what is going on here. Is there an article that explains the join hints? If not, perhaps that's a good area for a future article. MSDN wasn't particularly helpful to me on this. I suspect that they expect me to have some base level of knowledge that I'm lacking. :crying:

    Typically SQL server selects the best execution plan for a query and MS recommends that join hints be used as a last resort.

    Check out the See Also links on the Join Hints BOL page

    http://msdn.microsoft.com/en-us/library/ms173815.aspx

  • Got it correct...

    ===========================================
    Better try and fail than not to try at all...

    Database Best Practices[/url]

    SQL Server Best Practices[/url]

  • Learning more and more each day! Thanks!

  • Got it wrong but it was a very good question. Need to research this.

    ---------------
    Mel. 😎

  • Join hints is new to me n gonna learn this today..thanks for the question:-)

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

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