Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

The Right Kind Of Join Expand / Collapse
Author
Message
Posted Wednesday, August 24, 2011 7:08 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 10:34 AM
Points: 3,261, Visits: 1,955
Nice question. I look forward to more questions related to join hints.
Post #1164634
Posted Wednesday, August 24, 2011 8:08 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, July 24, 2014 8:41 AM
Points: 2,818, Visits: 2,553
Really interesting question, thanks
Post #1164709
Posted Wednesday, August 24, 2011 9:17 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:53 AM
Points: 1,176, Visits: 778
thanks - great question
Post #1164778
Posted Wednesday, August 24, 2011 10:09 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, July 25, 2014 1:11 PM
Points: 1,117, Visits: 1,230
Thanks for the question!


Post #1164828
Posted Wednesday, August 24, 2011 10:38 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Friday, July 18, 2014 3:37 PM
Points: 3,123, Visits: 1,256
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.


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



Post #1164839
Posted Wednesday, August 24, 2011 4:57 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, September 25, 2013 6:23 AM
Points: 392, Visits: 405
Got it correct...

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

Database Best Practices

SQL Server Best Practices
Post #1165046
Posted Thursday, August 25, 2011 6:10 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, July 24, 2014 1:50 PM
Points: 532, Visits: 448
Learning more and more each day! Thanks!
Post #1165265
Posted Friday, December 23, 2011 10:33 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 12:51 PM
Points: 462, Visits: 226
Got it wrong but it was a very good question. Need to research this.

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

It's no fun if it's not complicated.

Post #1226318
Posted Thursday, January 24, 2013 9:17 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Wednesday, February 20, 2013 1:45 AM
Points: 616, Visits: 97
Join hints is new to me n gonna learn this today..thanks for the question
Post #1411451
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse