Avoiding Transactions Altogether
Other than avoiding making database modifications, there's really no way to completely disable transaction logging. Some operations generate a minimum of log information, but there's no configuration option that turns off logging altogether.
Commands That Minimize Logging
The CREATE INDEX, BULK INSERT, TRUNCATE TABLE, SELECT… INTO, and WRITETEXT/UPDATETEXT commands minimize transaction logging by causing only page operations to be logged. (BULK INSERT can, depending on the circumstances, create regular detail log records.) Contrary to a popular misconception, these operations are logged—it's just that they don't generate detail transaction log information. That's why Books Online refers to them as nonlogged operations—they're ...
Get Guru's Guide to SQL Server Architecture and Internals, The now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
