Azure SQL
Delete data in batches
MSMitchel Sellers
6 d ago
Deleting 18 Million Rows in Azure SQL Without Downtime
Mitchel Sellers describes how he purged over 18 million historical rows from an S1-tier Azure SQL database by deleting small, committed batches instead of one large statement. The article covers batch sizing, clustered-key range selection, supporting indexes and production monitoring. It is a practical guide for any .NET developer planning a large data cleanup on a shared database.