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

Knowledge Measure

  1. True or false: The Simple recovery model fully logs all operations except nonlogged operations such as BULK INSERT.

  2. When COMMIT is executed from within a nested transaction, what percentage of the transaction's modifications is written to the transaction log?

  3. When ROLLBACK is executed from within a nested transaction, what percentage of the transaction's modifications is rolled back?

  4. True or false: SQL Server automatically rolls back a transaction that was initiated from an aborted Transact-SQL batch.

  5. Is Transact-SQL's CREATE INDEX command a member of the list of nonlogged (or minimally logged) commands?

  6. Describe the difference between a fully logged and minimally logged command.

  7. What DBCC command reports the oldest active transaction ...

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