|
|
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
|
|