The Right Kind Of Join

  • Kiara

    SSCarpal Tunnel

    Points: 4185

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

    -Ki

  • rfr.ferrari

    SSCertifiable

    Points: 6879

    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!
  • Britt Cluff

    SSCertifiable

    Points: 5083

    Learned something new again today, thanks.

    http://brittcluff.blogspot.com/

  • Ernie Schlangen

    SSCrazy

    Points: 2382

    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:

  • Kameswari Aravindh

    SSCrazy

    Points: 2380

    Good Question on Join Hints. 🙂

  • Ken Wymore

    SSCoach

    Points: 16614

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

  • Daniel Bowlin

    SSC-Dedicated

    Points: 34566

    Really interesting question, thanks

  • OzYbOi d(-_-)b

    Hall of Fame

    Points: 3994

    thanks - great question 🙂

  • skrilla99

    SSCertifiable

    Points: 5795

    Thanks for the question!

  • kevin.l.williams

    SSCarpal Tunnel

    Points: 4916

    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

  • BuntyBoy

    SSCommitted

    Points: 1876

    Got it correct...

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

    Database Best Practices[/url]

    SQL Server Best Practices[/url]

  • Tee Time

    Hall of Fame

    Points: 3693

    Learning more and more each day! Thanks!

  • SqlMel

    SSCrazy

    Points: 2891

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

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

  • kalyani.k478

    Default port

    Points: 1400

    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