MCAD/MCSE/MCDBA 70-229 Exam Cram 2: Designing & Implementing Databases w/SQL Server 2000 Enterprise Edition

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]

queries

     BULK INSERT statement

     DELETE statement 2nd 3rd

     EXECUTE statement

     INNER JOIN statement 2nd

     INSERT statement 2nd 3rd

     optimizing with Query Optimizer 2nd 3rd 4th

         execution plan caching and sharing 2nd

         hints 2nd 3rd 4th 5th 6th 7th 8th

         reading execution plans 2nd 3rd 4th 5th

     OUTER JOIN statement 2nd 3rd

     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

     TRUNCATE TABLE statement

     UNION statement 2nd 3rd

     UPDATE statement

Query Analyzer 2nd 3rd

Query Governor Cost Limit option (server properties)

query hints

Query Optimizer 2nd 3rd 4th

    execution plans

         caching and sharing 2nd

         reading 2nd 3rd 4th 5th

     hints 2nd 3rd

         join hints

         query hints

         table hints 2nd 3rd

Query Wait option (server properties)

QUOTED_IDENTIFIER option (databases)