Post reply

The Right Kind Of Join

  • August 24, 2011 at 5:27 am

    #1372475

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

    -Ki

  • August 24, 2011 at 5:30 am

    #1372477

    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!

  • August 24, 2011 at 5:39 am

    #1372480

    Learned something new again today, thanks.

    http://brittcluff.blogspot.com/

  • August 24, 2011 at 5:54 am

    #1372487

    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:

  • August 24, 2011 at 5:55 am

    #1372488

    Good Question on Join Hints. 🙂

  • August 24, 2011 at 7:08 am

    #1372528

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

  • August 24, 2011 at 8:08 am

    #1372597

    Really interesting question, thanks

  • August 24, 2011 at 9:17 am

    #1372660

    thanks - great question 🙂

  • August 24, 2011 at 10:09 am

    #1372701

    Thanks for the question!

  • August 24, 2011 at 10:38 am

    #1372708

    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

  • August 24, 2011 at 4:57 pm

    #1372887

    Got it correct...

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

    Database Best Practices[/url]

    SQL Server Best Practices[/url]

  • August 25, 2011 at 6:10 am

    #1373069

    Learning more and more each day! Thanks!

  • December 23, 2011 at 10:33 am

    #1425231

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

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

  • January 24, 2013 at 9:17 pm

    #1580804

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

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

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