MCTS 70-431 Exam Cram: Implementing and Maintaining Microsoft SQL Server 2005 Exam

Index

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

value() method

VALUES keyword, system views

varbinary data type

varbinary(max) declarations

varchar data type

varchar(max) declarations

VERIFYONLY option, RESTORE statements

views [See also tables.]

     aggregated data

     benefits of

    indexed

         ANSI NULLS

         ANSI PADDING

         ANSI WARNINGS

         binding tables

         CONCAT NULL YIELDS NULL

         IGNORE DUP KEY

         implementation settings

         Query Optimizer

         QUOTED IDENTIFIER

         SCHEMABINDING clause

         SET command

     partitioned

     partitioning

     standard

     system views

         ALTER INDEX REBUILD statements

         ALTER TABLE NOCHECK CONSTRAINT statements

         CLR

         common views list

         DISABLE INDEX statements

         DISABLE TRIGGER statements

         dynamic management views

         ENABLE TRIGGER statements

         FROM clause

         INSERT SELECT statements

         INSERT statements

         inserting complete recordsets

         inserting data, disabling functionality

         inserting individual records

         SELECT INTO statements

         stored procedures 2nd

         temporary views

         UDT

         VALUES keyword