A two-dimensional object, consisting of rows and columns, used to store data in a relational database. Each table stores information about one of the types of objects modeled by the database.
table lock
A lock on a table, including all data and indexes.
TCP/IP(Transmission Control Protocol/Internet Protocol)
An industry standard network protocol used by most companies for internetworking computer equipment.
tempdb
The database that provides a storage area for temporary tables, temporary stored procedures, and other temporary working storage needs.
TOP
The TOP keyword can be used in conjunction with the SELECT statement to select the top n rows or a percentage of the resultset rows.
trace
The SQL Profiler method for recording server events.
trace flags
Flags that can be enabled to aid in troubleshooting.
transactional replication
A type of replication where data and database objects are distributed by first applying an initial snapshot at the Subscriber and then later capturing transactions made at the Publisher and propagating them to individual Subscribers. Transactional replication, as with all replication types, begins with a synchronizing snapshot. After the initial synchronization, transactions, which are committed at the Publisher, are automatically replicated to the Subscribers.
Transact-SQL (T-SQL)
The language containing the commands used to administer instances of SQL Server, create and manage all objects in an instance of SQL Server, and to insert, retrieve, modify, and delete all data in SQL Server tables. T-SQL is an extension of the language defined in the SQL standards published by the International Standards Organization (ISO) and the American National Standards Institute (ANSI).
trigger
A trigger is a stored procedure that is fired when data is modified from a table using any of the three modification statements: DELETE, INSERT, or UPDATE. FOR and AFTER are synonymous, and are usually implied when referring to triggers, rather than INSTEAD OF triggers. Triggers are often created to enforce referential integrity or consistency among logically related data in different tables.