MCITP Administrator: Microsoft SQL Server 2005 Optimization and Maintenance (Exam 70-444) Study Guide

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