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,253 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,804 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,277 reads
2015-10-07
1,376 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,753 reads
Blogs
SQL on-demand in Azure Synapse Analytics
By James-Serra
The new SQL on-demand (to be renamed SQL serverless) offering within Azure Synapse Analytics...
My First Hand-built AWS CodePipeline
I’ve just completed my first, successful, AWS CodePipeline. I’m sorry to say it took...
Fixing Broken Pip
By Steve Jones
I’ve got Python 3.8 on my machine, and recently I got a note that...
Forums
Using Begin Tran for a select statement?
Hello All I have an overly complex SELECT statement that I am married to...
Exclude square bracket and text from start or end of string
Hi, I want to remove square brackets and text from either start of string...
MCSA Certifications - SQL2016
Dear all - Firstly apologies if my post isn't specifically for this particular forum...
Ask SSC