Community

Optimize Large SQL Server Insert, Update and Delete Processes by Using Batches

(Eduardo Pivaral) Sometimes you must perform DML processes (insert, update, delete or combinations of these) on large SQL Server tables. If your database has a high concurrency these types of processes can lead to blocking or filling up the transaction log, even if you run these processes outside of