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) |