N

named instances, SQL Server, 25–26

named pipes, 3

namespaces

AMO (Analysis Management Objects), 154

data source connection objects and, 6

.NET Framework, 425

RMO (Replication Management Objects), 150

SMO (Server Management Objects), 147

Native XML Web Services, 357

network libraries, installed as DLL files, 2

network protocols, 2–4

New Query window, SQL Management Studio, 54

NO ACTION, foreign key constraints, 197

nodes method, XQuery methods, 84

non-clustered indexes

columns and index depth and, 307–312

compared with clustered, 305

covered indexes, 305–307

created with unique keys, 196

exercise comparing with clustered indexes, indexed views, and non-indexed baseline, 330

exercise optimizing query, 327–328

non-key columns in, 466

organization of, 463

structures of, 465

non-repeatable reads, concurrency problems, 235

Non-Uniform Memory Architecture. See NUMA (Non-Uniform Memory Architecture)

normalization

de-normalizing an aggregation, 335

de-normalizing databases, 333

DML triggers for controlling denormalized data, 210

of data, 49

Notification Services, 357

NOWAIT, locking hints, 261

NTILE, ranking function, 58

NTLM authentication, endpoints, 20

NULL values

check constraints and, 200

empty strings contrasted with, 60

replacing with specific values, 60

NUMA (Non-Uniform Memory Architecture)

architecture of, 408

configuring for more than 32 processors, 412

configuring soft-NUMA support, 411–413

hardware trends, 407

memory nodes, 410

NUMBER, ranking function, 58

nvarchar data type, 335