Luhar (9/14/2012)
we have 4 million records in our test dbHow to delete them batch wise....Can you gimme a hint
Here's a useful script which Lynn Pettis prepared earlier: http://www.sqlservercentral.com/Forums/FindPost1357526.aspx
You have 4 million rows in your test db which classifies it as "very small", but of those, how many rows do you currently delete?
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden