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 1234»»»

Is a foreign key constraint an index? If not, is an index automatically created in order to enforce it? Expand / Collapse
Author
Message
Posted Saturday, August 2, 2014 12:24 PM


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: 2 days ago @ 9:41 AM
Points: 598, Visits: 2,603
Comments posted to this topic are about the item Is a foreign key constraint an index? If not, is an index automatically created in order to enforce it?


Best wishes,

Phil Factor
Simple Talk
Post #1598964
Posted Sunday, August 3, 2014 10:24 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 1:23 PM
Points: 18,179, Visits: 16,233
Really surprised by the point value of this question.

Good fundamental question.




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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1599062
Posted Sunday, August 3, 2014 1:13 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:53 AM
Points: 5,909, Visits: 13,105
me too, but who's complaining?

---------------------------------------------------------------------

Post #1599068
Posted Sunday, August 3, 2014 1:16 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 1:23 PM
Points: 18,179, Visits: 16,233
george sibbald (8/3/2014)
me too, but who's complaining?


Me!! Take my points back. I protest!!




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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1599071
Posted Sunday, August 3, 2014 2:05 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, January 20, 2015 10:48 AM
Points: 1,111, Visits: 3,188
SQLRNNR (8/3/2014)
george sibbald (8/3/2014)
me too, but who's complaining?


Me!! Take my points back. I protest!!

Good question, but I think I'll keep mine
Post #1599074
Posted Sunday, August 3, 2014 4:51 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: 2 days ago @ 1:16 PM
Points: 8,027, Visits: 9,737
Just like the others who have commented so far I think this is a good fundamental question which has ben assigned far too many points.

Tom
Post #1599076
Posted Monday, August 4, 2014 12:34 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: 2 days ago @ 5:54 AM
Points: 920, Visits: 1,576
Nice question, surprisingly too many people still fall for it if you ask them in a interview

Thanks for sharing Phil.

Post #1599122
Posted Monday, August 4, 2014 12:50 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 10:09 AM
Points: 13,863, Visits: 11,746
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 #1599124
Posted Monday, August 4, 2014 1:21 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, January 8, 2015 11:23 PM
Points: 1,804, Visits: 786
TomThomson (8/3/2014)
Just like the others who have commented so far I think this is a good fundamental question which has ben assigned far too many points.


Hope this helps...

Ford Fairlane
Rock and Roll Detective





Post #1599135
Posted Monday, August 4, 2014 1:22 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 4:54 AM
Points: 2,682, Visits: 2,528
I read question and answers many times because of high score.
I was searching for the swindle!
But it's only a straightforward basic question.
Post #1599136
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse