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] ideal Certified Information Systems Auditor candidate identity columns IGNORE DUP KEY, indexed views image data type IMPERSONATE permissions, deletion privileges impersonations importing/exporting data BCP BULK INSERT statements disconnected techniques live updates OPENROWSET statements SSIS standard view IN keyword indexed views ANSI NULLS ANSI PADDING ANSI WARNINGS CONCAT NULL YIELDS NULL IGNORE DUP KEY implementation settings Query Optimizer QUOTED IDENTIFIER SCHEMABINDING clause SET command tables, binding indexes ALTER INDEX REBUILD statements clustered 2nd covering CREATE INDEX command database tuning strategies analyzing existing indexes determining what not to index determining what to index fill factor indexed views maintaining indexes DBCC INDEXDEFRAG command defragmentation DISABLE INDEX statements FILLFACTOR setting full-text 2nd nonclustered 2nd pad index setting PADINDEX setting partitioned tables partitioning storage structure of unique values, importance of XML INIT option, BACKUP statements INNER JOIN statements INSERT ... SELECT * FROM OPENROWSET(BULK) statements INSERT SELECT statements, system views INSERT statements, system views int data type INTEGRATED authentication (SQL Server) inter-application messaging [See Service Broker.] INTO clause, system views ISNULL function |