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: Today @ 12:20 PM
Points: 3,397, Visits: 2,023
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: Tuesday, November 4, 2014 12:48 PM
Points: 2,818, Visits: 2,566
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: Saturday, October 11, 2014 3:26 PM
Points: 1,107, Visits: 1,243
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: Monday, November 17, 2014 1:28 PM
Points: 3,189, Visits: 1,271
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: 531, Visits: 448
Learning more and more each day! Thanks!
Post #1165265
Posted Friday, December 23, 2011 10:33 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Monday, November 17, 2014 3:18 PM
Points: 625, Visits: 392
Got it wrong but it was a very good question. Need to research this.

---------------
Mel.
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