Provides an overview of the background process that deletes records off of pages that have been marked for deletion.

Contains information on index architecture, and best practices to help you design effective indexes.

Explains how SQL Server manages memory, as well as memory utilization while reading and writing pages.

Describes the data structures that are used to manage pages and extents in all versions of SQL Server.

An overview of some common performance scenarios encountered after migrating to SQL Server and how to resolve them.

Covers how SQL Server processes queries and optimizes query reuse through execution plan caching.

Provides information about the physical and logical architecture of the transaction log.

Explains how SQL manipulates threads and tasks, which help dictate application logic and execution paths.

Describes the locking and row versioning mechanisms the SQL Server Database Engine uses to ensure the physical integrity of each transaction.