2018-08-27
832 reads
Foreign Keys (FK)
2018-06-05
852 reads
2016-08-16
1,317 reads
2016-08-02
1,321 reads
2016-07-05 (first published: 2016-05-26)
769 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,846 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)
5,016 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,552 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)
14,183 reads
Blogs
Abuse, Patience, and Understanding
By Steve Jones
I’ve been struggling with an author for a few months. I tried to work...
Daily Coping 21 Jun 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
SSIS Logging – Linking sysssislog with custom log
I was working on an ETL solution, which was expected to run for hours....
Forums
cumulative updates in multi instance standalone server
For 2019, how would one go about applying CU on multiple instances in a...
Powershell String was not recognized as a valid DateTime
Hello experts, I'm trying to import some CSV data into a SQL database using...
connecting to SQL Database from asp application and setting CONTEXT_INFO
connecting to SQL Database from asp application and setting CONTEXT_INFO. <connectionStrings> <add name="CLHN_AppConnectionString" connectionString="Data...
Ask SSC