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: 2 days ago @ 9:46 AM
Points: 3,150, Visits: 1,900
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: Monday, April 14, 2014 2:16 PM
Points: 2,812, Visits: 2,543
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, April 04, 2014 6:01 PM
Points: 1,117, Visits: 1,217
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, March 28, 2014 11:01 AM
Points: 3,047, Visits: 1,229
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: Today @ 6:23 AM
Points: 511, Visits: 417
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: Tuesday, March 25, 2014 7:31 AM
Points: 421, Visits: 177
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