Session

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.

Jared Poche

Database Engineer - ChannelAdvisor

Cary, North Carolina, United States

Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.

Jump to top