Index T


[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  



MCSE Training Guide (70-229). Designing and Implementing Databases with MicrosoftR SQL ServerT 2000 Enterprise Edition
MCSE Training Guide (70-229). Designing and Implementing Databases with MicrosoftR SQL ServerT 2000 Enterprise Edition
ISBN: N/A
EAN: N/A
Year: 2003
Pages: 228

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net