Adventures In Foreign Keys 3: Why Cascading Deletes Perform Slowly

Legendreary In the last post, I looked at some issues with implementing foreign keys with cascading actions. Namely that, well, it fell apart pretty quickly just trying to set up. I didn’t even get to the point where I wanted to test all those relationships. But there’s an even worse surprise waiting for you if…
Read More

Foreign Keys in SQL Server (video)

Foreign Keys
Learn the basics of Foreign Keys in SQL Server: trust, join elimination, cascading deletes, and indexing child keys. Limited on time? Check out the Table of Contents below. Table of Contents: 03:46 – Foreign keys change performance 04:12 – Let’s say we have no foreign key 04:41 – This query has a join 05:05 –…
Read More