Derek Dongray (2/3/2009)
I'm not aware of any way to do deletions without any transaction logging at all.
All data modifications in SQL are logged, one way or another. It's not possible to do any modification without logging it.
If it was it would not be possible to roll such a statement back and, if the DB crashed part way through, the result would be a transactionally inconsistent database.
hdpanjabi: Why do you think that the tran log is the bottleneck? Have you followed all recommendations regarding the placing and sizing of the log?
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass