T

Index

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X]

T-SQL [See Transact SQL]
T-SQL (Transact-SQL)
     functions
TABLE CHECK constraints
table data type
table hints 2nd 3rd
tables 2nd 3rd 4th
     columns 2nd
         column descriptors 2nd
     cross joins 2nd
     definition of 2nd
     FOREIGN KEY constraints 2nd
     inner joins 2nd
     outer joins 2nd 3rd
     PRIMARY KEY constraints 2nd 3rd
    rows
         counting
     syscolumns
     syscomments
     sysdatabases
     sysindexes
     syslogins
     sysmessages
     sysobjects
     sysprocesses
     sysremotelogins 2nd
     systypes
     sysusers
     unions 2nd 3rd
TABLOCK hint
TABLOCKX hint
tempdb database 2nd
templates
     SQL Profiler
tests [See 70-229 exam]
text
     spaces, trimming
     string functions 2nd 3rd
text data type
thick clients
thin clients
third normal form
third-party database interactions 2nd
three- or more tier systems 2nd
time/date functions
     DATEADD() 2nd
     DATEDIFF() 2nd
     DATENAME() 2nd
     DATEPART() 2nd
     GETDATE()
timestamp data type
tinyint data type
tools 2nd 3rd 4th
     Analysis Services
     BCP (Bulk Copy Program)
     Books Online 2nd
     Client Network
     English Query
     OSQL (ODBC Structured Query Language)
     Profiler
     Query Analyzer 2nd 3rd
     Server Network
     Service Manager 2nd
TOP clause (SELECT statement) 2nd
top rows, returning 2nd
TORN_PAGE_DETECTION option (databases)
traces
     defining 2nd
     diagnosing locking with 2nd 3rd
     playback and diagnosis 2nd
Transact SQL 2nd [See also functions] [See also stored procedures]
     ALTER DATABASE statement 2nd
     ALTER TRIGGER statement 2nd
     ALTER VIEW statement
    BACKUP statement
         moving data with 2nd
     BEGIN TRANSACTION statement 2nd 3rd
     BEGIN...END statement 2nd
     BREAK statement
     BULK INSERT statement
     CASE statement 2nd 3rd
     CLOSE statement
     comments 2nd
     COMMIT TRANSACTION statement
     COMMIT WORK statement
     CONTINUE statement
     CREATE DATABASE statement 2nd 3rd 4th
         COLLATE clause
         FILEGROWTH clause
         MAXSIZE clause 2nd
     CREATE FUNCTION statement 2nd
     CREATE INDEX statement 2nd 3rd
     CREATE PROCEDURE statement 2nd 3rd
     CREATE TRIGGER statement 2nd
     CREATE VIEW statement 2nd
     cursors 2nd 3rd 4th 5th 6th
         closing
         creating 2nd
         deallocating
         DYNAMIC
         FAST_FORWARD
         fetching rows from
         FORWARD_ONLY
         GLOBAL
         KEYSET
         LOCAL
         OPTIMISTIC
         READ_ONLY
         SCROLL_LOCKS
         scrolling
         STATIC
         TYPE_WARNING
         updating 2nd
    data types
         casting
         converting
     DBCC DBREINDEX statement
     DEALLOCATE statement
     DECLARE CURSOR statement 2nd
     DELETE statement 2nd 3rd
     DROP INDEX statement
     DROP TRIGGER statement
     DROP VIEW statement
     EXECUTE statement
     FETCH NEXT statement
     GRANT statement 2nd 3rd
     IF...ELSE statement 2nd
     INNER JOIN statement 2nd
     INSERT statement 2nd 3rd
     loops 2nd 3rd
     OPEN statement
     OUTER JOIN statement 2nd 3rd
    RESTORE statement
         moving data with 2nd
     REVOKE statement 2nd
     ROLLBACK TRANSACTION statement 2nd
    scripts
         batches 2nd 3rd 4th 5th
         definition of
     SELECT statement
         arithmetic operators
         BETWEEN keyword
         bitwise operators
         column names, specifying 2nd
         comparison operators 2nd
         COMPUTE BY clause
         COMPUTE clause
         CUBE keyword 2nd
         DISTINCT clause
         EXISTS keyword
         EXPLICIT clause 2nd
         FOR XML clause 2nd
         FROM clause
         GROUP BY clause 2nd
         HAVING clause
         IN keyword
         INTO clause 2nd
         LIKE keyword 2nd
         logical operators 2nd
         NULL values 2nd
         OPENXML keyword 2nd 3rd
         ORDER BY clause 2nd
         ROLLUP keyword 2nd
         SET ROWCOUNT clause
         simple example 2nd 3rd
         TOP clause 2nd
         unary operators
         WHERE clause
     SET IMPLICIT_TRANSACTIONS statement
     triggers 2nd 3rd 4th
         AFTER 2nd
         altering
         creating 2nd
         dropping
         firing order 2nd 3rd
         guidelines for use 2nd
         INSTEAD OF 2nd 3rd 4th
         renaming
     TRUNCATE TABLE statement
     UNION statement 2nd 3rd
     UPDATE statement
    variables
         assigning values to 2nd
         declaring
         definition of
         global variables 2nd
         scope
    VIEW statement
         WITH ENCRYPTION clause
Transact-SQL) [See T-SQL]
transactional replication 2nd 3rd
transactions 2nd 3rd
     atomicity
     beginning 2nd
     consistency 2nd 3rd
     durability
     isolation
     isolation levels 2nd
     rolling back 2nd
triggers 2nd 3rd 4th 5th 6th 7th 8th
     AFTER 2nd 3rd
     altering
     creating 2nd
     definition of
     dropping
     firing order 2nd 3rd
     guidelines for use 2nd
     INSTEAD OF 2nd 3rd 4th 5th
     renaming
troubleshooting
     failed object creation 2nd
    security issues
         broken ownership chains 2nd 3rd
         SQL Profiler 2nd
TRUNCATE TABLE statement
tuning [See performance tuning]
Two Digit Year Cutoff option (server properties)
two-tier systems 2nd
TYPE_WARNING cursors
types [See data types]