Generate Script for existing Foreign Keys for any emergency.
2016-07-05 (first published: 2016-05-26)
Learn how trusted foreign keys (FK) can help or hurt performance.
2018-08-24 (first published: 2016-03-08)
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)
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)
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)