N


N+1 clusters, 171

named instances, linked servers on, 467468

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, 248250, 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, 171172

NO_TRUNCATE option, 193

node IDs in query plans, 84

NOINDEX option, 307

NOLOCK hint, 140

Non transacted updates option, 462

nonclustered indexes, 9899

nonrepeatable reads, 123

NORECOMPUTE option, 114

NORECOVERY option and mode

BACKUP LOG, 193

log shipping, 173

RESTORE DATABASE, 197

NOT FOR REPLICATION constraint, 492493

Notification Services subsystem, 560

notifications, event, 274280, 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



MCITP Administrator. Microsoft SQL Server 2005 Optimization and Maintenance Study Guide (70-444)
MCITP Administrator: Microsoft SQL Server 2005 Optimization and Maintenance (Exam 70-444) Study Guide
ISBN: 0470127457
EAN: 2147483647
Year: 2004
Pages: 146

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net