I

IAM (Index Allocation Map) bitmaps, 39, 44–5

id (object identifier) column, 45

IDENT_CURRENT function, 427, 580

IDENT_INCR function, 580

IDENT_SEED function, 580

identifiers, 155, 165

security, 104–105, 349–350

T-SQL, 328–329

identity column values, 426

IDENTITY function, 581

IDENTITY property, 167, 374, 447, 457, 581

identity validation, 99, 101

IDENTITY_INSERT statements, 426

IDENTITYCOL property, 457

IDEs (Integrated Development Environments), SQL, 403

idoc, OpenXML, 520

IETF (Internet Engineering Task Force’s) Kerberos v5, 106–107

If... Else option, 325

IF COLUMNS_UPDATED() triggers, 389

IF UPDATE() triggers, 389

IF…ELS function, 581

IL (Intermediate Language), 337–338, 345

image and text functions, T-SQL, 319

image data type, 304–305, 583

Image function, 581

immediate updating, 220

implicit transactions mode, 501

important restore, 183

Import/Export Wizard, 83

IN function, 581

IN logical operator, 298

Incidents tables, 525

incomplete transactions, 46

inconsistent analysis problems, 489

increment, CREATE TABLE statements, 167

Index Allocation Map (IAM) bitmaps, 39, 44–45

index identifier (indid), 45

Index page, 39

INDEX_COL function, 581

Indexed Sequential Access Method (ISAM), 63

indexed views, 477–479

indexes, 30–34, 44, 173–176

INDEXKEY_PROPERTY function, 581

INDEXPROPERTY function, 581

indid (index identifier), 45

indirect recursion, 392

in-line functions, 38

inner join statements, 471–472

INSERT statements, 423–435, 581

calling stored procedures, 410

and computed columns, 166

with default values, 367, 430

errors, 430

with EXECUTE statement, 429

with NULL, default, and system-supplied values, 426–428

overview, 423–425

with SELECT statement, 428–429

and table variable, 436

and tables, 441

Updategram delete example, 526

and FOR XML query TYPE directives, 517

Insert updategram, 525

Instance Name dialog box, MS Cluster Service, 279

instant file initialization, 139

instantaneous counters, 540

INSTEAD OF triggers, 382, 388

int data type, 308, 581

int integers, 301

integer constants, 292

integer data type, 301, 468

integer string-based data types, 296

Integrated Development Environments (IDEs), SQL, 403

integrity, data. See data integrity

intent exclusive (IX) locks, 493–494

intent locks, 492–493

intent shared (IS) locks, 493–494

interdomain keys, 112

Interfaces feature, CLS, 335

Intermediate Language (IL), 337–338, 345

internal backup facilities, 188

internal database level, 21–22

International Organization for Standardization (ISO), 12

Internet, 7–8, 10, 15

Internet Engineering Task Force’s (IETF) Kerberos v5, 106–107

interoperability, .NET Framework, 9

Interprocess Communications (IPC), 14, 78

INTERSECT function, 577

INTO function, 425, 581

intranets, 7–8

intra-query parallelism, 263

invalid pages, 54

inventory table, 26, 36

I/O architecture, 57–58

I/O performance, 139–140

IP addresses, 272, 276, 282, 284

IPC (Interprocess Communications), 14, 78

IS (intent shared) locks, 493–494

IS [NOT] NULL function, 581

IS NOT NULL expression, 462

IS_MEMBER function, 581

IS_SRVROLEMEMBER function, 581

IsAlive checks, 275

ISAM (Indexed Sequential Access Method), 63

ISDATE function, 581

ISNULL function, 581

ISNUMERIC function, 581

ISO (International Organization for Standardization), 12

isolation, 60–61

isolation, transaction, 489–490

IX (intent exclusive) locks, 493–494