identities
checking, 304–305
in replication, 493
service, 338
IIS for SSRS, 343
immediate updating
replication, 429, 505
subscriptions, 176
Imminent subscription expiration warning, 499
IMPERSONATE permission, 579
impersonation, 585–586
Import Column transforms, 377
included columns, missing indexes with, 79
incompatible jobs, 321
incremental backup strategies, 184–185, 187
Index as access path option, 462
Index Properties window, 110, 110
INDEX query hint, 91
Index Tuning Wizard (ITW), 52
Index Usage Statistics reports, 49
INDEXDEFRAG command, 51, 106, 310–312
indexes
architecture, 94–97, 95
clustered, 97–98
covering, 100–101
DMVs, 34
dropping, 108
fragmentation, 102–103, 102–103, 108–111
defragmenting, 310–312
degree, 312–314
detecting, 103–105
implementing, 88
maintaining, 105–106
missing, 79
nonclustered, 98–99
optimization, 101–105
for query performance, 71
rebuilding, 107–108, 309
reorganizing, 106–107
statistics for, 111–114
inequality predicates, missing indexes with, 79
infections, virus, 530–531
INIT option, 193
initialization status, 339
Initialize Subscriptions page, 489, 489
injection attacks, 528–529
inner joins, 405–407, 405, 407
inputs in job dependency diagrams, 320
installing SSIS, 362–363, 363
instance-aware services, 560
instance-level DMVs, 33
common language runtime, 33–34
full-text indexes, 34
I/O, 35
query notifications, 35
replication, 35–36
service broker, 36
SQL operating system, 36–38
instance-level information, SQLH2 for, 323
instance performance
Activity Monitor, 29–30, 30
dedicated administrator connection, 38
default trace, 29
DMVs. See instance-level DMVs
error log files, 27–28, 28
Summary Report pane, 25–27, 25–26
system functions, 32, 32
System Monitor, 7
system stored procedures, 30–31, 31
tools, 24
trace flags, 33
troubleshooting, 38–39
I/O bottlenecks, 44–45
memory, 42–44
processors, 39–42, 41
tempdb problems, 45–47
INSTEAD OF triggers, 266–269
int data type, 440
Integration Service. See SQL Server Integration Services (SSIS)
Integration Services subsystem, 560
integrity, 426–427
checking, 301–304
constraints vs. triggers, 445
data conflicts, 427–434
data types, 439–445
entity, 435
replication, 492–494
interjob dependencies, 320
internal attacks, 533–536, 534–536
internal fragmentation, 312
Internet Protocol Security (IPSEC), 491
INTERSECT operator, 422–424, 424
I/O
bottleneck troubleshooting, 23–24, 44–45
DMVs, 35
performance object counters
baselines, 230–231
thresholds, 236–237
in query plans, 83
isolation levels
locks, 138
transactions, 123–126
iterative processes, queries, 116
ITW (Index Tuning Wizard), 52