Interesting question - thanks!
I was wrongly under the impression that SQL Server didn't mark records for deletion. FoxPro does that also, but FoxPro uses a hidden column on the table to mark them. So, how does the SQL engine mark the records as deleted?
The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking