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 Tuesday, August 23, 2011 9:48 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 9:31 AM
Points: 11,194, Visits: 11,137
Comments posted to this topic are about the item The Right Kind Of Join



Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #1164395
Posted Tuesday, August 23, 2011 9:48 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:18 PM
Points: 5,589, Visits: 24,946
Very nice ...

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #1164396
Posted Tuesday, August 23, 2011 10:55 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 3:27 PM
Points: 21,631, Visits: 15,289
Nice question



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1164414
Posted Wednesday, August 24, 2011 12:36 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 6:57 AM
Points: 952, Visits: 1,159
Good question.

“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
Post #1164433
Posted Wednesday, August 24, 2011 1:39 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:44 PM
Points: 3,907, Visits: 5,083
Interesting question, thanks

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1164462
Posted Wednesday, August 24, 2011 2:41 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 4:41 AM
Points: 833, Visits: 2,439
Pure guess work from me...
Post #1164489
Posted Wednesday, August 24, 2011 2:49 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 7:25 AM
Points: 1,215, Visits: 2,205
There would have been less guesswork involved if the full error message had been given instead of just an extract:

Query processor could not produce a query plan because of the hints defined in this query. Resubmit the query without specifying any hints and without using SET FORCEPLAN.
Post #1164495
Posted Wednesday, August 24, 2011 3:10 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 9:28 AM
Points: 13,570, Visits: 10,447
Great question, thanks.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1164508
Posted Wednesday, August 24, 2011 3:17 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, August 28, 2013 7:06 AM
Points: 1,216, Visits: 308
Nice question.
Post #1164515
Posted Wednesday, August 24, 2011 3:30 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 9:31 AM
Points: 11,194, Visits: 11,137
Andrew Watson-478275 (8/24/2011)
There would have been less guesswork involved if the full error message had been given instead of just an extract

You can get the full error text without running the query by checking sys.messages:

SELECT
m.[text]
FROM sys.messages AS m
WHERE
m.message_id = 8622
AND m.language_id = 1033

I'm comfortable that the question and answers had the right level of detail to make it interesting (it is a 2 point question after all).




Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #1164518
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse