Index_I

I

ident_current() function, 198-199

Identities

returning value of last inserted, 198

working with, 195-199

Identity columns, 196

avoiding, 227-228

clustered indexes on, 227

replication and, 430-432

resetting the seed of, 195

on subscribers, 442

IDENTITY keyword, 195

IDENTITY_INSERT option, 430-431

Idle CPU Condition option, 101

Ignore All Index Hints trace flag, 156

Image column pointer, 229

Image fields

avoiding using, 226

DPVs and, 333

when using ADO in ASP, 231

IN clause, vs. EXISTS clause, 242

Include Execution Trace Messages option, 100

Index fill factors, optimizing, 247-248

Index Tuning Wizard, 253-254

Indexed Views, 333-338

creating, 336-338

data types and clauses to avoid, 334-335

deterministic restriction, 335-336

querying, 338

requirements and restrictions, 334-336

SET options for, 334

Indexes

defragging, 252-253

dropping before warehousing data, 252

finding out where space is used, 174

optimizing, 247-254

used by which tables, 473

where to place, 253-254

Indexes installed in a table, list of, 472-473

Informational messages, 135, 465

Informational messages installed, listing, 465

Injection attacks, 82-90

auditing through Profiler, 89

gathering information from, 85-89

Insert process, tips to speed up, 242

Installation Selection dialog box, 19

Installation (SQL Server)

and files and directories, 22

setup steps, 8

tips, 7-24

InstallShield, 8-9

Insufficient resource errors, 135

Integer (int) data type, 225

Integration environment, 53

Internet Connector license, 14

IP addresses

assigning server names to, 214

mapping with machine names, 214

preclustering considerations, 378

virtual, 370, 372, 403

IsAlive checks, 372, 410, 414

isql utility, 166-167