Large deletes = blocking.
✅ Safe pattern
DELETE TOP (1000) FROM Logs
Loop until rows = 0.
Bits of .NET
Daily micro-tips for C#, SQL, performance, and scalable backend engineering.
Daily micro-tips for C#, SQL, performance, and scalable backend engineering.
Large deletes = blocking.
DELETE TOP (1000) FROM Logs
Loop until rows = 0.