2018-08-27
830 reads
Foreign Keys (FK)
2018-06-05
852 reads
2016-08-16
1,316 reads
2016-08-02
1,317 reads
2016-07-05 (first published: 2016-05-26)
722 reads
Trust, or Verify – How FKs Can (or Cannot) Help Performance
Learn how trusted foreign keys (FK) can help or hurt performance.
2018-08-24 (first published: 2016-03-08)
5,129 reads
Foreign Key Indexes and Binding
Understand what FK's do and how they use indexes. Then use my script to see if they're using good indexes.
2018-06-29 (first published: 2016-02-10)
4,759 reads
Auto-suggesting foreign keys and data model archaeology
If you can understand the data model then you can understand the intent of the application developers.
2018-07-06 (first published: 2016-01-26)
4,216 reads
2015-10-07
1,375 reads
Indexing Foreign Keys
Foreign Keys are one of the fundamental characteristics of relational databases and enforce the referential integrity. Is it a good idea to index a FK relationship? When can it help?
2016-09-16 (first published: 2015-06-29)
13,631 reads
Blogs
Information Measurement with SQL Server, Part 4.9: The Bregman Divergence
By Steve Bolton …………Before closing out this long-delayed segment on stochastic information distances, I...
Let’s Talk About The Cloud
I’m launching a new initiative called the Community Circle Cloud Conversation Club (c5 for...
Daily Coping 29 May 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Daily Coping 29 May 2020
Today’s tip is today link your decisions and choices to your purpose in life....
Week Ending Thursday, can some one tweek my code?
What I have missed from this code? I'm trying to show the DateTimeRaised field...
The Matchbox Database
Comments posted to this topic are about the item The Matchbox Database
Ask SSC