The Right Kind Of Join

Question

Post reply

The Right Kind Of Join

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

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

Kiara SSCarpal Tunnel Points: 4185 More actions · Answer 1

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

-Ki

rfr.ferrari SSCertifiable Points: 6879 More actions · Answer 2

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 More actions · Answer 3

Learned something new again today, thanks.

http://brittcluff.blogspot.com/

Ernie Schlangen SSCrazy Points: 2382 More actions · Answer 4

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 More actions · Answer 5

Kameswari Aravindh

SSCrazy

Points: 2380

August 24, 2011 at 5:55 am

#1372488

Good Question on Join Hints.

Ken SSCoach Points: 17191 More actions · Answer 6

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

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 7

Daniel Bowlin

SSC-Dedicated

Points: 34566

August 24, 2011 at 8:08 am

#1372597

Really interesting question, thanks

OzYbOi d(-_-)b SSCarpal Tunnel Points: 4054 More actions · Answer 8

OzYbOi d(-_-)b

SSCarpal Tunnel

Points: 4054

August 24, 2011 at 9:17 am

#1372660

thanks - great question

skrilla99 SSCertifiable Points: 5795 More actions · Answer 9

skrilla99

SSCertifiable

Points: 5795

August 24, 2011 at 10:09 am

#1372701

Thanks for the question!

Kevin SSCarpal Tunnel Points: 4962 More actions · Answer 10

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 More actions · Answer 11

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: 3745 More actions · Answer 12

Tee Time

Hall of Fame

Points: 3745

August 25, 2011 at 6:10 am

#1373069

Learning more and more each day! Thanks!

SqlMel SSCrazy Points: 2901 More actions · Answer 13

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

---------------
Mel.

kalyani.k478 Default port Points: 1400 More actions · Answer 14

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

The Right Kind Of Join

Cookies on SQLServerCentral