n placeholder, 169
N+1 cluster configurations, 265–266
NAME keyword, 148, 154
name resolution, deferred, 391
Named Pipes components, 78
names
backup devices, 193
database, 432
SQL Server Backup General page, 195
namespaces, 100, 343
naming convention, SQL Server table, 27–28
Naming feature, CLS, 335
Native Client, SQL, 252
nchar data type, 304, 582
NCHAR function, 314, 582
nchar(n) data type synonyms, 308
Negative (–) operator, 559
Negative (-) unary operator, 299
nested expressions, 299
nested stored procedures, 412–413
nested triggers, 393
nested XML elements, 512
.NET Framework, 8–9, 79, 350–351, 385, 399
net send commands, 89–90
Net-Libraries, 51, 78–79
netmodules, 346
network addresses, default monitored, 80
Network attribute, 251–252
network bandwidth, 556
network configuration, Cluster Service, 271
network connections, 282
network considerations, modeling multinode server clusters, 276
Network Monitor Agent tool, 535
network names, 276, 284
New Database dialog box, Management Studio, 158–159
new media sets, SQL Server Backup Options page, 196
New Publication Wizard, Management Studio, 226–231
New Subscription Wizard, Management Studio, 221–226
new_table placeholder, 458
NEWID function, 168, 375, 428, 582
NEWNAME option, MODIFY FILE argument, 154
NEWSEQUENTIALID function, 583
NO ACTION events, 35
NO_WAIT argument, 155
nonclustered indexes, 33, 45, 169, 175, 376
nondeterministic functions, 310–311
nondeterministic resource cleanup, 341
nonoperational database mode, 200
nonrepeatable reads, 489
nontrusted access, 107–110, 117–118
non-Unicode data types, 303–305
normalization, 446
NOT (~) operator, Bitwise, 296
NOT BETWEEN expression, 462
not equal (<> or !=) operators, 462
Not Equal comparison operators, 297
Not Equal To (<>) operator, 561
Not Equal To (!=) operator, 561
NOT FOR REPLICATION arguments, 168–169, 376–377, 388
NOT function, 583
not greater than (!>) operator, 297, 462
Not Greater Than (!>) operator, 561
NOT IN keywords, 463
not less than (!<) operator, 297, 462
Not Less Than (!<) operator, 561
NOT logical operator, 298, 461
NOT NULL constraints, 35, 166, 375
NT File System (NTFS), 104
ntext data type, 304–305, 308, 583
NTFS (NT File System), 104
n-tier client/server systems, 15
NULL keyword
CONSTRAINT keyword, 375
in CREATE TABLE statements, 168
Data rule, 357
and DISTINCT argument, 454
in INSERT statements, 425–428
and logical database architecture, 28
and search condition, 462
and type integrity, 361
nullability of computed columns, 166
NULLIF function, 583
numeric constants, 293
numeric data type, 301, 574, 583
NUMERIC_ROUNDABORT Sql_option, ALTER DATABASE statements, 157
nvarchar data type, 304, 582
nvarchar(n) data type synonyms, 308