Trust, or Verify – How FKs Can (or Cannot) Help Performance

Learn how trusted foreign keys (FK) can help or hurt performance.

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.

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.

Composite foreign key

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?

Delete

Show Table Parents

Which parent tables must contain rows before inserting in to TableX?

Drop and Re-Create All Foreign Key Constraints in SQL Server

Aaron Bertrand supplies a script which generates two separate sets of commands: one to drop all foreign key constraints, and one to create them again. These scripts are stored in a table so that, if you drop the constraints and then disaster of some kind strikes during the create, you still have everything handy and can troubleshoot if needed.

Running Out Of Foreign Keys

It's Not All About The Keys