I

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