Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

How to avoid lock escalation for chunk deletes in mssql? #3645

Unanswered
FS-FrankLakmann asked this question in Q&A
Discussion options

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

You must be logged in to vote

Replies: 0 comments

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Category
Q&A
Labels
None yet
1 participant

AltStyle によって変換されたページ (->オリジナル) /