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)
730 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,581 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,901 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,409 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,970 reads
Blogs
Azure Platform Series “You have exceeded the maximum amount of scale changes within the past hour”
By HamishWatson
This blog post relates to where you might be doing scale operations of your...
Bash: “command not found” in IF statement
By HamishWatson
This blog post is about a situation where writing an IF THEN ELSE statement...
The First Data Saturday is Tomorrow
By Steve Jones
Data Saturday #2 – Guatemala is tomorrow. This is the first event on the...
Forums
Database Architecture
Hi Experts, Our architecture team come up with a new plan to have multiple...
Calling remote powershell script through SQL server agent
I have a powershell script in remote server. When I go to remote server...
Data Privacy Grows in California
Comments posted to this topic are about the item Data Privacy Grows in California
Ask SSC