Tag: foreign keys

SQL Server insights from 25+ years in the field

Performance tips, security advisories, health check findings, and industry analysis. Practical, technically accurate, no fluff.

SQL Server Foreign Keys: Balancing Data Integrity and Performance
22 Oct 2026 · 7 min read

SQL Server Foreign Keys: Balancing Data Integrity and Performance

Foreign keys prevent orphaned records but cause lock contention and slow writes when poorly designed. Here is how to get the balance right.

Read article →
How to Drop and Recreate Foreign Key Constraints in SQL Server
15 May 2018 · 6 min read

How to Drop and Recreate Foreign Key Constraints in SQL Server

Learn how to safely drop and recreate foreign key constraints in SQL Server using system catalogue views to generate precise ALTER TABLE scripts automatically.

Read article →

SQL Server insights, monthly.

Performance tips, security advisories, and industry analysis. No fluff, no spam.