N+1 clusters, 171
named instances, linked servers on, 467–468
NAT (network address translation), 531
natural primary keys, 435
nchar data type, 442
Nested queries option, 462
nested triggers, 263
NetValidatePasswordPolicy call, 576
network address translation (NAT), 531
network I/O performance object counters, 237
Network Monitor Agent, 6
Network Service account, 558
networks
access limitations, 557
monitoring, 227
in performance, 3
New Alert window, 248–252, 248–250, 252
New Job Schedule dialog box, 331, 331
New Operator window, 249, 249, 253
New Publication Wizard, 429, 429, 482, 482
New Subscription Wizard, 486, 486
N+M clusters, 171–172
NO_TRUNCATE option, 193
node IDs in query plans, 84
NOINDEX option, 307
NOLOCK hint, 140
Non transacted updates option, 462
nonclustered indexes, 98–99
nonrepeatable reads, 123
NORECOMPUTE option, 114
NORECOVERY option and mode
BACKUP LOG, 193
log shipping, 173
RESTORE DATABASE, 197
NOT FOR REPLICATION constraint, 492–493
Notification Services subsystem, 560
notifications, event, 274–280, 275
Notify Operators option, 249, 253
NOTRUNCATE option
DBCC SHRINKFILE, 316
SHRINKDATABASE, 315
NOWAIT hint, 140
Number of Deadlocks/sec counter, 233
numeric data type, 441
nvarchar data type, 442