2 added 25 characters in body
source | link

Not sure if it will make a difference but this syntax should work:

DELETE TOP (500)
FROM ErrorReports
WHERE IncidentId = 611

I tested on a simple table and get a very simple query plan with a single index scan.

Not sure if it will make a difference but this syntax should work:

DELETE TOP (500)
FROM ErrorReports
WHERE IncidentId = 611

I tested on a simple table and get a very simple query plan.

Not sure if it will make a difference but this syntax should work:

DELETE TOP (500)
FROM ErrorReports
WHERE IncidentId = 611

I tested on a simple table and get a very simple query plan with a single index scan.

1
source | link

Not sure if it will make a difference but this syntax should work:

DELETE TOP (500)
FROM ErrorReports
WHERE IncidentId = 611

I tested on a simple table and get a very simple query plan.