P

p (precision) data types, 301

page checksum error 826, 138

page files, 54–55

Page Free Space (PFS) pages, 39, 44

page locks, 491

PAGE_VERIFY CHECKSUM option, database recovery, 158

page-level restore, 138

pagers, 89–90

pages, 39–40

parameter elements, XML, 519, 522

parameterized queries, 442–444

parameters, stored procedure, 407, 410–411, 419

parent elements, XML, 512

parentheses, 299

parsed XML documents, 521

PARSENAME function, 584

parser, statement, 68

partial clusters, 269

partitioned views, 30, 262–263, 479–482

partitioning, data, 140, 212

partitions, raw, 148

PascalCase, 27

passive cluster configurations, 264–265

passive mirrors, 244–245

passive servers, 244–245, 261

passwords, 101, 135

PATH mode, T-SQL FOR XML clause, 517–518

PATINDEX function, 320–321, 584

PE (Microsoft Portable Executable) format, 343–345

PE (Portable Executable) format, Microsoft, 343–345

penetration tests, MBSA, 279

percent (%) suffix, FILEGROWTH, 149

PERCENT option, SELECT TOP statements, 455

performance baseline data, 536

Performance Console, 540, 542–543

performance counters, 535, 539, 544–545

Performance Counters Reference, OS, 538

performance management, 256–257

Performance Monitor, 549–551

performance monitoring, 257, 538–540

Performance page, Task Manager, 542

permission argument, 134

permissions, 99–100, 406, 442, 459

permissions cache, 127

PERMISSIONS function, 584

persistent storage module, Structured Query Language (SQL/PSM), 13–14

pessimistic concurrency control, 61

pessimistic locking architecture, 491

Petkovic, Dustin, 9

PFS (Page Free Space) pages, 39, 44

phantom data or reads, 489

physical data or reads, 57

physical database architecture, 39–46

database files and filegroups, 40–42

extents, 40

overview, 39

pages, 39–40

space allocation and reuse, 42–44

table and index organization, 44–45

transaction logs, 45–46

physical disks, 142

physical memory, 52–53

physical replication models, 231, 232

physical writes, 58

PI function, 318, 584

PKI (public key infrastructure), 117

platform monitoring tools, 540–551

Add Counters dialog box, 544–546

monitoring with T-SQL statements, 548–549

overview, 540

Performance Console, 542–543

Performance Logs and Alerts, 549–551

Processes page, 542

SQL Server objects, 546–548

System Monitor, 543–544

Task Manager, 541–542

platter devices, 205

POF (points of failure), 255

Pointers feature, CLS, 335

points of failure (POF), 255

Portable Executable (PE) format, Microsoft, 343–345

Positive (+) operator, 559

Positive (+) unary operator, 299

pound (#) signs, 329

POWER function, 318, 584

precedence

collation, 308

data type, 299–300

operator, 298–299

rule of, 306, 452, 461

precision (p) data types, 301

< predicate > placeholder, 461–462

Predicate expression, 585

prepare phase, two-phase commit process, 502

PRI (procedural referential integrity), 360

primary data files, 24, 40–41

primary filegroups, 42, 141

primary files, 144

PRIMARY KEY constraints, 35, 166, 168, 374–376

primary keys, 31, 33, 307, 361, 430

PRIMARY keyword, 148

Primary Net-Library, 79

primary nodes, SQL Service Cluster, 268–269, 283

primary servers, 233

PRINT function, 585

print-spooling services, 267

private assemblies, 346

PRIVILEGES argument, 134

proactive server analysis, 531

problem detection, 256–257

procedural referential integrity (PRI), 360

procedure cache, 56, 70, 401

PROCEDURE statements, 402

Processadmin fixed server role, 122

process status structure (PSS), 127

Processes page, Task Manager, 542

processor bandwidth, 258

Processor Time, 554

Profiler, SQL, 83, 175, 534–536

Profiler90.EXE, 83

programming for integrity. See data integrity

programming languages, 290

Prolog elements, XML documents, 510–511

prompts before restoring backup, Management Studio, 198

Properties dialog box

SQL Server, 85–86

System Monitor, 544–545

Properties feature, CLS, 335

protocols

interprocess communication, 78

and Network attribute in fail-over, 252

proxy tickets, 112

pseudocode, trigger, 386

PSS (process status structure), 127

public key cryptography, 116

public key infrastructure (PKI), 117

public user roles, 122

publication component, SQL Server replication services, 215

published data, 218–220

Publisher component, SQL Server replication services, 215, 220

publishing, key, 117

publishing database objects/schema objects, 219

PUBLISHINGSERVERNAME function, 585

pull subscriptions, 232

push subscriptions, 232