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]

TABLE CHECK constraints

table-valued

tables [See also views.]

     ALTER TABLE statements, DEFAULT option

     columns 2nd

         computed

         identity

         NOT NULL property

         NULL property

         timestamp data type

     constraints

     CREATE TABLE statements, DEFAULT option

    customizing

         combining columns

         renaming columns

         returning top rows

         trimming white space

    data types

         list of

         timestamp

         UDT

         UDT. CLR

         xml

         XML schema collections

    deleting data

         DELETE statement

         DENY statements

         escalating deletion privileges

         GRANT statements

         REVOKE statements

         TRUNCATE TABLE method

     determining purpose of

     filtering data

     grouping data

     indexed views

     indexes

         clustered

         CREATE INDEX command

         DBCC INDEXDEFRAG command

         FILLFACTOR setting

         nonclustered

         PADINDEX setting

         storage structure of

         unique values, importance of

     joining

         CROSS JOIN statements

         INNER JOIN statements

         LEFT JOIN statements

         OUTER JOIN statements

         RIGHT JOIN statements

     keys

         foreign key relationships

         many-to-many relationships

         one-to-many relationships

         one-to-one relationships

         primary key relationships

     listing contents of

     object assignments

     partitioning

         advantages of

         ALTER DATABASE statements

         asymmetric design

         CREATE PARTITION FUNCTION statements

         CREATE PARTITION SCHEME statements

         data storage

         indexes

         $PARTITION queries

         row/column access patterns

         strategies for

         symmetric design

         table size

     rows 2nd

     statistics

     stored data, sampling

     system tables

     temporary tables (system views)

     triggers

         DDL

         DML

     updates

TABLESAMPLE clause

TABLOCK hint

tail-log backups

templates, SQL Profiler

temporary tables (system views)

tests

    practice

         answer keys 2nd

         questions 2nd

     readiness

text data type

throughputs

    importing/exporting data

         BCP

         BULK INSERT statements

         disconnected techniques

         live updates

         OPENROWSET statements

         SSIS

     readings/resources

     Service Broker

         assembling components into services

         components of

         creating queues

         defining message type

         dialogues

         providing contract details

timestamp data type 2nd

tinyint data type

TOP clause

trace flags

     data mirroring

     SQL Server performance

traces, SQL Profiler

     defining in

     locking diagnosis example

     replaying in

transaction log backups 2nd

transaction processing

transactional consistency

transactional replication 2nd

Transactions event class (SQL Profiler)

triggers

     AFTER, cascading actions

     DDL

     DISABLE TRIGGER statements

     DML

     ENABLE TRIGGER statements

TRIM function

troubleshooting

     alerts, setting via SQL Server Agent

     blocks

     deadlocks

     locks

     SQL Server, readings/resources

TRUNCATE ONLY option, BACKUP statements

TRUNCATE TABLE method

TRY/CATCH constructs

TSQL event class (SQL Profiler)