Cleaning a table in production

The question it answers

How do you fix bad data without taking the application down?

This lecture is being written. Like every lecture here, each claim in it is read in its primary source and cited to the page before it is published. See what you can read now.