MCITP Administrator: Microsoft SQL Server 2005 Optimization and Maintenance (Exam 70-444) Study Guide

A component of a report used in SQL Server Reporting Services to display data using a tabular format.

The part of the transaction log that has been changed since the last log backup.

A Windows operating system tool that shows what processes are running; the amount of memory, CPU, and networking resources used; and other performance-related metrics.

Transmission Control Protocol/Internet Protocol. An Internet-based network protocol that is used for communicating between network nodes.

Test-Driven Development. A software development process that involves repeatedly first writing a test case and then implementing only the code necessary to pass the test.

Tabular Data Stream. A low-level protocol used between a client application and a SQL Server instance.

A system database used by SQL Server 2005 as a global temporary workspace.

Amount of activity a system can sustain over a period of time.

A collection of events and related performance data returned by SQL Server’s database engine.

Variation of the Structured Query Language (SQL) used by Microsoft SQL Server.

A group of DML operations combined into a logical unit of work that is either wholly committed or rolled back. (See ACID.)

A write-ahead log used by the SQL Server storage engine for recording transaction made to the database.

One or more files used by SQL Server’s storage engine to store the database’s transaction log.

A replication type that relies on DML operations being captured from a published database and automatically sent to the subscriber database(s). Starts with a snapshot of the publication. Incremental changes both in data and schema at the source are replicated to the destination as they occur.

Changing data in various ways as it goes through the data flow.

Table-Valued Function. A user-defined function that returns a table.