T

Table layout

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

Tail log

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

Task Manager

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.

TCP/IP

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

TDD

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.

TDS

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

tempdb

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

Throughput

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

Trace

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

Transact-SQL

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

Transaction

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

Transaction log

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

Transaction log files

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

Transactional replication

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.

Transform

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

TVF

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