GilaMonster (6/17/2013)

---

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.