O'Reilly logo

Guru's Guide to SQL Server Architecture and Internals, The by Ken Henderson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required