I

IA64 processors, 348

Idera's SQLscaler, 378

Import and Export Wizard

creating SSIS packages using, 158–162

executing packages with, 171

inactive (passive) node, for clustering, 654, 657–658

index access methods

clustered index scan

ordered, 469–471

unordered, 467–468

clustered index seek, 473–475

nonclustered index scan

ordered, 471

unordered, 468–469

nonclustered index seek, 471–473

table scan, 465–467

index creation memory option, 401

index fragmentation, 475–476

Index Tuning Wizard (ITW), 483. See also DTA (Database Tuning Advisor)

indexed views, 483

indexes

aligned, 387

asynchronous statistics update, 482

DTA (Database Tuning Advisor) for, 483–484

fragmentation of

cleaning up, 498–500

monitoring, 497–498

full text indexes, 482

for inserts, 500–509, 520–523

large, dropping and rebuilding, 483

lock granularity for, 483

maintenance of, 496–500

new features for, 481–484

non-key columns in nonclustered indexes, 482

number of, too many, 523–525

online index operations, 482

parallel index operations, 482

partitioning, 382–389, 481, 486–488, 490

tuning queries using

adding indexes, 508–512, 520–523

assessing query performance, 500–506

DTA recommendations for, 506–509, 512–520

for updates, 509–520, 520–523

usage of, monitoring, 435–437

version store, 483

on XML columns, 483

in-place upgrade, 54–55, 56

(INST) token, 134

installation

burning in SQL Server after, 38–39

options, planning for, 24–28

post-install configuration, 39–44

remote installation, 30–34

of sample databases, 34–37

scripted installation, 29–30

of Service Broker application, 254–256

of SSAS, 37

troubleshooting, 47–50

types of, 28–29

instances. See also logins for SQL Server instance

clustering multiple instances on same server, 662

fast start of, support for, 15

multiple instances of SQL Server, 28–29

named instances, SSIS, 150–151

number of, supported, 15

instant database file initialization, 43, 614

int data type, 10, 11

Integrated Security, Windows, 75

Integration Services, SQL Server (SSIS)

business uses of, 146–147

configuring, 150–154

constraints in, 148

controlflows in, 147

dataflow engine and dataflow components, 149

dataflows in, 147

definition of, 145–146

event logs for, 155–156

failures of, responding to, 152

jobs executing packages from, 106, 107

named instances, handling, 150–151

object model of, 149

packages in

creating, 158–163

definition of, 158

deploying, 166–170

digital signatures for, 178

execution of, 171–175, 178

exporting, 166, 170

importing, 165–166, 170

managing, 163–165

resources used by, 178

saving, 177

scheduling execution of, 173–175

security for, 176–177, 178

templates for, 162–163

performance monitoring for, 156–158

runtime engine and runtime components of, 147–148

security for, 175–178

Service component of, 147, 150

startup properties, 151–152, 153

support for, by SQL Server edition, 15

tasks in, 147–148

upgrading DTS to, 67–71

Windows Firewall modifications for, 153–154

interleaved memory, 345

I/O

bottlenecks, 378–382

database I/O, 453–454

disk I/O, 363–365

network I/O, 363

performance considerations for, 345, 362–365

requirements for, 367–368

I/O affinity, 400–401

"I/O Architecture" (Books Online topic), 379

I/O Manager, 379

IPX/SPX, 65

isql.exe program, 64, 330. See also sqlcmd program

ITW (Index Tuning Wizard), 483. See also DTA (Database Tuning Advisor)