I have a table which is frequently subjected to large
bulk inserts, updates, and deletions. The data is 100%
temporary, meaning I will never have a need to restore it
from a backup.
My problem is this. Several hundred million updates are
made to this table daily, causing the transaction log to
grow by several GB/hr. Is there any way I can keep SQL
from logging these transactions?