This is how I do it with a little bit of output. You can shorten it up by removing the RaisError output message.

While (1=1)

Begin

Delete Top (10000) From

[DimProductStyle]

From

[DimProductStyle] With (nolock)

Left...

You lost me at a few minutes vs a couple of seconds. If that were truly the case you would have to add an index no matter what, a...