One more reason to use foreign key constraints

Question

One more reason to use foreign key constraints

Louis Davidson (@drsql)

SSCommitted

Points: 1647
More actions
April 27, 2024 at 12:00 am

#4415142

Comments posted to this topic are about the item One more reason to use foreign key constraints

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004378 More actions · Answer 1

Good article. Thanks for taking the time to write it up and post it.

Just like humans, AI can use all the help it can get but (and just to say it out loud)... That shouldn't be the driving reason. The driving reason for FKs is DRI and DRI is a serious part of proper data modeling.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 2

A number of tools already use DRI information (FK) to build their internal data model. (entity framework etc...)

But if the current evolution of AI is the drive to - finally - get decent sql server hosted data systems, by all means! Hurray!

People should also realise they should - by default - support their FK with matching indexes ! ( unless it is proven they give a huge performance hit )

Meaning: indexes matching the referred primary key / unique index in column sequence and order.

Please have a look at Grant's article "Yes, Foreign Keys Help Performance"

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me