2018-08-27
837 reads
Foreign Keys (FK)
2018-06-05
857 reads
2016-08-16
1,320 reads
2016-08-02
1,339 reads
2016-07-05 (first published: 2016-05-26)
2,618 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)
6,506 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,723 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)
5,209 reads
2015-10-07
1,377 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)
15,163 reads
Blogs
Future Data Driven 2023 is This Week
By Steve Jones
The Future Data Driven 2023 virtual conference is coming on Wednesday, September 27. Register...
Opening the SQL Prompt Command Palette
By Steve Jones
A few years ago SQL Prompt added a command palette to let you search...
Common Mistakes in SQL Server – Part 2
The Identity property creates an incremental value for the specified column automatically, which is...
Forums
Identifying the process that is backing the databases to virtual device
We have about 20 SQL Servers. We use Net backup or Native backup for...
SQL Migration - Identifying Connections - Best approach
I have one SQL Database server which is old version and planning to migrate...
Restore With Standby; A Review and A Lesson Learned
Comments posted to this topic are about the item Restore With Standby; A Review...
Ask SSC