لطفا منتظر باشید ...
T
table
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. For example, an education database would have one table for teachers, a second for students, and a third for classes. The columns of a table represent an attribute of the modeled object (for example, first name, last name, and address). Each row represents one occurrence of the modeled object.
table data type
A special data type used to store a result set for later processing.
table-level constraint
Constraints that allow various forms of data integrity to be defined on one column (column-level constraint) or on several columns (table-level constraints) when the table is defined or altered. Constraints support domain integrity, entity integrity, and referential integrity as well as user-defined integrity.
table lock
A lock on a table (including all data and indexes).
table scan
A data retrieval operation where the database engine must read all the pages in a table to find the rows that qualify for a query.
Tabular Data Stream (TDS)
The SQL Server internal client/server data transfer protocol. TDS allows client and server products to communicate regardless of operating-system platform, server release, or network transport.
tape backup
A backup operation to any tape device supported by Windows NT 4.0 and Windows 2000. If you are creating a tape backup file, you must first install the tape device by using Windows NT 4.0 and Windows 2000. The tape device must be physically attached to the SQL Server that you are backing up.
target object
See source and target.
target partition
An Analysis Services partition into which another is merged and that contains the data of both partitions after the merger. See also source partition.
task
See job.
task object
A Data Transformation Services (DTS) object that defines pieces of work to be performed as part of the data transformation process. For example, a task can execute a SQL statement or move and transform heterogeneous data from an OLE DB source to an OLE DB destination by using the DTS Data Pump.
TDS
See Tabular Data Stream (TDS).
tempdb database
The database that provides a storage area for temporary tables, temporary stored procedures, and other temporary working storage needs.
temporary stored procedure
A procedure placed in the temporary database, Tempdb, and is erased at the end of the session.
temporary table
A table that is placed in the temporary database, Tempdb, and is erased at the end of the session.
text data type
A SQL Server system data type that specifies variable-length non-Unicode data with a maximum length of 2^31 – 1 (2,147,483,647) characters. The text data type cannot be used for variables or parameters in stored procedures.
theta join
A join based on a comparison of scalar values (=, >, >=, <, <=, < >, !<, and !>).
thread
An operating system component that allows the logic of multi-user applications to be performed as several separate, asynchronous execution paths. The SQL Server relational database engine executes multiple threads in order to make use of multiple processors. The use of threads also helps ensure that work is being performed for some user connections even when other connections are blocked (for example, when waiting for a disk read or write operation to complete).
time dimension
A dimension that breaks time down into levels such as Year, Quarter, Month, and Day. In Analysis Services, the time dimension is a special type of dimension created from a date/time column.
timestamp data type
A SQL Server system data type that is a monotonically increasing counter whose values are always unique within a database.
tinyint data type
A SQL Server system data type that holds whole numbers from 0 through 255. Its storage size is one byte.
tool
A SQL Server application that has a graphical user interface (GUI) used to perform common tasks.
trace file
A file that SQL Profiler uses to record monitored events.
training data set
A set of known and predictable data used to train a data mining model. See also mining model training.
trait
An attribute that describes an entity. For example, blood type is a trait of patients.
Transact-SQL
The language that contains the commands used to administer instances of SQL Server, to create and manage all objects in an instance of SQL Server, and to insert, retrieve, modify, and delete all data in SQL Server tables. Transact-SQL is an extension of the language that is defined in the SQL standards published by the International Organization for Standardization (ISO) and the American National Standards Institute (ANSI).
Transact-SQL cursor
A server cursor defined by using the Transact-SQL DECLARE_CURSOR syntax. Transact-SQL cursors are intended for use in Transact-SQL batches, stored procedures, and triggers.
transaction
A group of database operations combined into a logical unit of work that is either wholly committed or rolled back. A transaction is atomic, consistent, isolated, and durable.
transaction log
A database file in which all changes to the database are recorded. SQL Server uses the transaction log during automatic recovery.
transaction processing
Data processing used to efficiently record business activities, called transactions, that are of interest to an organization (for example, sales, orders for supplies, or money transfers). Typically, online transaction processing (OLTP) systems perform large numbers of relatively small transactions.
transaction rollback
Rollback of a user-specified transaction to the last savepoint inside a transaction or to the beginning of a transaction.
transactional replication
A type of replication where an initial snapshot of data is applied at Subscribers, and then when data modifications are made at the Publisher, the individual transactions are captured and propagated to Subscribers. See also merge replication, snapshot replication.
transformable subscription
A subscription that allows data movement, transformation mapping, and filtering capabilities of Data Transformation Services (DTS) during replication.
transformation
In data warehousing, the process of changing data extracted from source data systems into arrangements and formats consistent with the schema of the data warehouse.
trigger
A stored procedure that executes when data in a specified table is modified. Triggers are often created to enforce referential integrity or consistency among logically related data in different tables.
trusted connection
A Windows network connection that can be opened only by users who have been authenticated by the network. The users are identified by their Windows login ID and do not have to enter a separate SQL Server login ID. See also Windows Authentication.
tuple
An ordered collection of members from different dimensions. For example, (Boston,_[1995]) is a tuple formed by members of two dimensions: Geography and Time. A single member is a degenerated case of a tuple and can be used as an expression without the parentheses. See also axis.
two-phase commit
A process that ensures that transactions applied to more than one server are completed on all servers or on none.
