D



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]

data consumption
    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
data filtering, conditional filtering
data heaps
data marts
data partitioning
     indexes
     joins
     performance, improvements to
     tables
         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
     views 2nd
data querying
     conditional data filtering
     full-text indexes
     SELECT statements
         GROUP BY clause
         HAVING clause
         ORDER BY clause
         TABLESAMPLE clause
         TOP clause
         WHERE clause
    tables
         combining columns
         filtering data
         grouping data
         joining
         listing contents of
         renaming columns
         returning top rows
         sampling stored data
         selecting null value rows
         trimming white space
data storage, partitioned tables
data types
     list of
     timestamp
     UDT
     xml
     XML schema collections
data updates
     computed columns
     data from previous SQL Server releases
     filtered updates
     multiple records
     object schemas
     positioned updates
     single records
     transaction processing
data warehouses
Database column (Activity Monitor)
Database Diagram tool
Database event class (SQL Profiler)
Database Properties dialog
databases
     administrators, replication
     ALTER DATABASE statements
     assemblies
    backups
         appending
         as system databases
         differential
         extra backups
         full
         initializing headers
         integrity of
         master databases
         media sets, creating
         model databases
         msdb databases
         overwriting
         read-only secondary servers
         recovery models
         reliability of
         removing inactive log entries
         restoring data from
         rewinding tape
         tail-log
         transaction logs
         truncating logs
         unloading tape
         validating data
         warm backup secondary databases
     components of
     CREATE DATABASE statements
     Database Diagram tool
     database diagrams
     DTA
     indexing strategies
         analyzing existing indexes
         determining what not to index
         determining what to index
         fill factor
         indexed views
         maintaining indexes
    maintenance
         readings/resources
         SQL Server
     master databases 2nd
     mirroring
     model databases 2nd
     msdb databases, backups
    objects
         associated objects, viewing
         creating
         implementing
     proxies
     roles
     snapshots 2nd
     statistics
     synonyms
     sys.databases catalog view
     system databases, backups as
     tables
    triggers [See DDL triggers.]
     views
         aggregate data
         benefits of
         indexed
         partitioned
         standard
     warm copies
datetime data type
DBCC (Database Console Command)
     maintenance operations
     miscellaneous operations
     options of
     server maintenance
     SQL Server performance
     validation operations
DBCC INDEXDEFRAG command
DBMS (database management system), SQL Server installations
DDL triggers
deadlocks
decimal data type
DEFAULT option
defragmenting indexes
delegations
DELETE statements
deleting
    table data
         DELETE statements
         DENY statements
         escalating deletion privileges
         GRANT statements
         REVOKE statements
         TRUNCATE TABLE method
     tables, cascading actions
DENY statements, data deletion privileges
Deprecation event class (SQL Profiler)
dialogues
     security
     Service Broker, creating in
differential backups
DIGEST authentication (SQL Server)
DISABLE INDEX statements
DISABLE TRIGGER statements
DISABLED state (endpoints)
disconnected techniques
disk systems, SQL Server installations
distributed partitioned view
distributors, role in replication 2nd
DML triggers
Do Not Keep Any Existing PDS option (PDS)
document returns (XML)
drives, SQL Server installations
DROP DATABASE statements, deleting database snapshots
DROP EXISTING option
DTA (Database Engine Tuning Advisor) 2nd
     Advanced Tuning Options section
     Partitioning Strategy to Employ section
     PDS
dynamic management functions and views 2nd




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