T



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)




MCTS 70-431(c) Implementing and Maintaining Microsoft SQL Server 2005
MCTS 70-431 Exam Cram: Implementing and Maintaining Microsoft SQL Server 2005 Exam
ISBN: 0789735881
EAN: 2147483647
Year: 2006
Pages: 200
Authors: Thomas Moore

Similar book on Amazon

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