I thought the contest was supposed to be SQL Server specific.

If I had known it was more general I could have told a few stories that would have made your hair stand on end!

I'd just like to know how it is possible to "turn off transaction logging", like was mentioned in the Valentines Day scenario. I wasn't aware that this could be done other than during bulk load operations.

Thanks,

James

You can't turn it off, but you can set the transaction log to truncate on checkpoint.  This is the same as "Simple" recovery mode.