SQL — DELETE Without Batching Locks Tables

SQL

Large deletes = blocking.

DELETE TOP (1000) FROM Logs

Loop until rows = 0.

Drop all the tables, stored procedures, triggers, constraints and all the dependencies in one sql st...

Post Views: 3