))
(AI Gen) Removing Foreign Key Constraints against Hot Tables
Manage episode 475102665 series 3611948
Content provided by Guy Coleman and Empower Finance. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by Guy Coleman and Empower Finance or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://ppacc.player.fm/legal.
A seemingly simple FK constraint drop turned into a high-stakes locking issue that threatened database stability. This post dives into the surprising chain reaction between two related tables and reveals a clever zero-downtime workaround using sp_rename. Perfect for engineers who love creative solutions to tricky schema changes—plus some spicy alternatives if you're feeling bold.
17 episodes
Share
