 <p>You could also try:</p> <pre><code>set rowcount 1000 delete from mytable where id in (select id from ids) set rowcount 0 --reset it when you are done. </code></pre> <p><a href="http://msdn.microsoft.com/en-us/library/ms188774.aspx" rel="nofollow">http://msdn.microsoft.com/en-us/library/ms188774.aspx</a></p>