Lokesh Vij (6/17/2013)
There is nothing called "No Logging" in SQL Server...there is something called "Minimal Logging". This can be achieved by using table locking hints.
DELETE FROM TableName with (TABLOCK) WHERE id > 100;
Err, no.
Minimal logging is for inserts, not deletes. You can't minimally log deletes.
The blog describes how to use TABLOCK on an insert to get minimal logging in bulk-logged and simple recovery.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability