Improving Concurrency: Data Modeling with Vertical Partitioning Reducing locking, blocking, and deadlocks in wide tables by distributing updates across one-to-one related tables Not long ago, I worked with a customer who was experiencing persistent blocking and occasional deadlocks in one of their core systems. The application itself wasn’t new, but over the years it had grown significantly. New features had been added, more processes were interacting with the database, and naturally the...