N

NAS (Network Attached Storage), 21, 23

Native XML Web Services

configuring, 81

default settings for, 75

nchar data type, 10

nested loop (loop join), 462–463

.NET runtime host, SQL Server as, 273–274

Network Attached Storage (NAS), 21, 23

Network Configuration, Configuration Manager, 41–42, 78

network I/O, 363

network service accounts, 28

networks, for clustering, 659

new installation, 28

nodes, for clustering, 654

nonclustered index scan

ordered, 471

unordered, 468–469

nonclustered index seek, 471–473

nonclustered indexes, non-key columns in, 482

non-key columns in nonclustered indexes, 482

non-uniform memory access (NUMA) systems

CC-NUMA, 395–396

definition of, 354

optimization, 345

normalization phase of query compilation, 439

Northwind database, 37, 64

notification, query, SQL Native Client used by, 5

notification services

for jobs, 108–109

support for, by SQL Server edition, 15

notifications, event

creating, 431–433

definition of, 417, 431

list of events for which to be notified, 433

for SQL Server Agent jobs, 108–109

for SQL Server Agent operators, 111–112

ntext data type, 10

NTFS file system

allocation unit size, 374

importance of using, 23

NUMA (non-uniform memory access) systems

CC-NUMA, 395–396

definition of, 354

optimization for, 345

numeric data type, 10, 11

numeric data types, list of, 10–11

nvarchar data type, 10

NWLink, 65