MCSE Training Guide (70-229). Designing and Implementing Databases with MicrosoftR SQL ServerT 2000 Enterprise Edition

[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]

queries

       nested queries

               derived tables   2nd  

               IN clauses   2nd  

       writing style  

Query Analyzer   2nd   3rd   4th   5th   6th   7th  

       altering

               with ALTER TRIGGER   2nd  

       caching and sharing execution plans   2nd  

       changing return string length  

       creating linked servers  

       executing T-SQL programs   2nd  

       execution plans   2nd   3rd  

       hints   2nd   3rd  

       indexes

               creating  

               rebuilding with DBCC DBREINDEX  

       INSERT trigger

               creating   2nd   3rd  

       nonclustered indexes

               creating   2nd  

       opening  

       reading execution plans   2nd   3rd  

       SET options   2nd   3rd  

       SET STATISTICS  

       triggers

               viewing   2nd  

query governor cost limit

       optimizing OS configurations   2nd  

querying

       index statistics   2nd  

       statistics

               indexing  

question types

       MCP Exams  

               drag-and-drop-style questions   2nd  

               dro-and-connect questions  

               hot area questions  

               multiple-choice questions   2nd  

               multiple-rating questions  

               ordered list questions  

               simulation questions   2nd   3rd   4th   5th  

               tree questions   2nd  

Queue Reader agent   2nd  

queued updating   2nd  

quotation marks  

QUOTED_IDENTIFIER database configuration option  

Категории