My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SQLCMD in SQL 2005 to delete lots of data in batches
The new RSS feed is here
So we've all come across the need to delete 10 million records. however we all no that this won't be quick and will result in a large log file and as we get nearer deleting the 10 millionth row the process is going very slowly.
... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SQLCMD in SQL 2005 to delete lots of data in batches