March 14, 2024
Jared Poche will be presenting :
One Bite at a Time: Deleting Millions of Rows from Production Systems
Many maintenance tasks operate piecemeal. Whether we are garbage collecting, archiving data, or anonymizing data, we’ll want to use the TOP operator to keep our operations bite-sized and our performance smooth. Backfilling a column or generating reports from an OLTP database can operate quite similarly. But there are some mechanics we’ll need to understand to get the most out of these processes. In this session, we’ll talk about the TOP operator, row mode execution, and blocking operators. We’ll have examples from public databases based on real world cases, and we’ll talk about anonymizing 15 million records containing PII in 5 minutes.