Randstad Digital

Engineered "ThePurge" — Batch Deletion Framework

Senior SQL Server Database Architect, Administrator, and Lead Developer2021

Situation

Production transaction log growth was becoming unstable. Several tables had grown beyond 60M rows, and the volume of deletes needed to stay in sync with client analytics teams was causing log bloat and nightly sync failures.

What I Did

Built a parameterized batch deletion framework (nicknamed "ThePurge") designed to safely process large volumes of rows in controlled batches — avoiding lock escalation and log saturation while hitting the nightly sync windows client analytics teams depended on.

Result

Stabilized production transaction log growth and ensured consistent nightly sync compliance with client analytics teams. The framework became standard for all bulk delete operations across the platform.

Tools & Tech

SQL ServerT-SQLPowerShell