If you want to do a quick one then
Create another table with same structure and insert the rows that you don't want to delete into the other table.
Now truncate the original table .Now the second table has all the rows you want. Now switch the names.
This way you won't block others because you are not performing any big transaction.
I have an article that is worth trying if you want to perform deletes efficiently.
Let me know if you have questions
This isn't necessarily correct. DELETE does not necessarily (and frequently doesn't) block anything.
is pronounced ree-bar and is a Modenism for R
First step towards the paradigm shift of writing Set Based code: Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
Although they tell us that they want it real bad, our primary goal is to ensure that we dont actually give it to them that way.
Although change is inevitable, change for the better is not.
Just because you can do something in PowerShell, doesnt mean you should. Helpful Links:
How to post code problemsHow to post performance problemsForum FAQs