>>The simplest way will be (assuming you can truncate the table)
>>

>>select top (100) * into #SaveResults from TableToClean order by SomeColumn
>>truncate table TableToClean
>>insert into TableToClean
>>select * from #SaveResults
>>drop table #SaveResults

>
>Truncate?

That's the politically rectified expression for zap.