[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 character functions cursors extensions 2nd 3rd data deleting 2nd formatting inserting into tables 2nd 3rd summarizing summarizing date functions. [See date functions] updating 2nd data retrieval functions creating mathematical functions 2nd 3rd SELECT system functions 2nd 3rd wildcard characters T-SQL ( Transact -SQL) changing configuration options creating databases programs, executing with OSQL 2nd 3rd with Query Analyzer 2nd table data type 2nd table-valued functions creating 2nd tables 2nd aliases 2nd CHECK constraints 2nd 3rd 4th column descriptors 2nd 3rd column-level permissions creating 2nd 3rd 4th T-SQL code data dictionaries 2nd defined derived tables 2nd derived tables. [See derived tables] Foreign Keys constraints 2nd 3rd indexes 2nd inserting data into 2nd 3rd INSERT EXECUTE 2nd INSERT INTO SELECT 2nd SELECT INTO 2nd joins. [See joins] placeing into filegroups Primary Keys constraints 2nd referential integrity relationships between tables defining 2nd 3rd 4th system tables temporarily locked tables indexing temporary tables and stored procedures 2nd 3rd 4th target audience for reports Tempdb Tempdb database templates monitoring 2nd SQL Profiler temporary tables and stored procedures 2nd 3rd 4th and variables of type table test practice displaying scores tests practice customized installing modes preconfigured reviewing the test timed uninstalling text placing into filegroups stored procedures 2nd text data type thick clients thin clients third normal form (3NF) 2nd 3rd 4th third-party database connectivity client/server model three- tier systems 2nd timestamp data type 2nd tinyint data type tips for taking exams 2nd adaptive exams 2nd case study exams fixed-form exams 2nd tools Current Activity window error logs Query Analyzer Query Analyzer. [See Query Analyzer] SNMP SQL Profiler 2nd SQL Profiler. [See SQL Profiler] SQL Server Profiler System Monitor 2nd 3rd 4th 5th 6th System Monitor. [See System Monitor] Transact-SQL TOP rows returning 2nd 3rd TORN_PAGE_DETECTION database configuration option traces creating 2nd playbacks 2nd requirements 2nd 3rd 4th 5th profile traces defining 2nd 3rd 4th 5th profile traces. [See profile traces] replays performing 2nd SQL Profiler creating 2nd 3rd Transact SQL Transact-SQL cursors extensions 2nd 3rd Transact-SQL (T-SQL) changing configuration options creating databases programs, executing with OSQL 2nd 3rd with Query Analyzer 2nd Transact-SQL. [See T-SQL] transaction logging disabling transactional consistency replication 2nd transactional replication 2nd 3rd filtering how it works 2nd 3rd 4th transactions designing 2nd enforcing procedural business logic 2nd managing 2nd 3rd control of flow 2nd 3rd data manipulation 2nd 3rd tree questions MCP exams 2nd trigger alerts Enterprise Manager TRIGGER NESTLEVEL triggers 2nd 3rd 4th 5th 6th 7th AFTER 2nd 3rd DELETE triggers INSERT triggers 2nd 3rd UPDATE triggers 2nd AFTER triggers 2nd ALTER TRIGGER 2nd altering 2nd with ALTER TRIGGER in Query Analyzer 2nd with Enterprise Manager 2nd and logging creating 2nd 3rd 4th INSERT trigger 2nd 3rd UPDATE trigger 2nd 3rd 4th when to create defining DELETE dropping 2nd 3rd INSERT 2nd 3rd 4th INSERT trigger creating with Query Analyzer 2nd 3rd INSTEAD OF 2nd 3rd 4th 5th guidelines for INSTEAD OF triggers modifications controlling 2nd nested triggers 2nd 3rd disabling order first and last 2nd recursive triggers type order 2nd overview of 2nd 3rd recursive triggers referential and data integrity enforcing 2nd 3rd 4th 5th renaming 2nd 3rd troubleshooting viewing triggers 2nd 3rd 4th 5th what prevents triggers from executing 2nd UPDATE 2nd UPDATE trigger creating with Enterprise Manager 2nd 3rd 4th viewing 2nd 3rd 4th 5th troubleshooting alternative mechanisms SNMP 2nd trace flags 2nd DBCC maintenance operations 2nd status operations 2nd validation operations 2nd SQL Server objects triggers viewing triggers 2nd 3rd 4th 5th what prevents triggers from executing 2nd with SQL Profiler TRUNCATE TABLE TRUNCATE TABLE statements Two-Phase Commit (2PC) two-tier systems 2nd Two-way phase commit type order of triggers 2nd TYPE WARNING 2nd TYPEPROPERTY types of replication 2nd of variables 2nd 3rd |