vk-kirov (10/31/2012)
craig 81366 (10/31/2012)
GilaMonster (10/31/2012)
You can't insert or delete a row multiple timesI beg to differ
...
that spool is essential to protecting against deleting more rows than expected
"Delete a row multiple times" and "Delete more rows than expected" – there is a big difference, I believe.
It seems to me that you're quibbling about how a questionable statement by GilaMonster differs from mine.
Perhaps take a look at the very last sentence of Craig Freedman's (not me) blog post:
http://blogs.msdn.com/b/craigfr/archive/2008/02/27/halloween-protection.aspx
He says he's been working for the SQL Server team for quite a few years, so probably can be considered authoritative on the matter. 😉
Edit: To clarify... it's not the statement "cannot delete a row multiple times" that I consider questionable. (Obviously :-P) It's questionable to use that as the explanation why DELETE's don't apply to the Halloween Problem.