I know just enough about this to be dangerous...so I have a basic question.

One of the posters (GSquared) offered this method:

select 1;

while @@rowcount > 0

delete top (1000)

from table

where x= y;

Is this simply for deleting in batches so the table remains available, or does this also affect the transaction log file size differently than a single "delete from table where x=y" ?

Thanks.