How to avoid lock escalation for chunk deletes in mssql? #3645
Unanswered
FS-FrankLakmann
asked this question in
Q&A
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
Hello,
from a table with millions of rows I want to delete a few 10k without locking the table.
Is there a better way than wrapping a delete top 500 where... in a stored procedure, mapping and calling that in a loop?
The IQueryable delete doesn't work with Take: forgotten bug issue
Maybe a maintainer sees this and has a look at the old issue.
Thanks for any idea
Frank
Beta Was this translation helpful? Give feedback.
All reactions