P

parameterized queries, 641

parameters

in CLR stored procedures, 346

input and output, 32-34

LOB, 349-354

passing by name, 38

passing by position, 38

parsing, 638

partitioning, horizontal and vertical, 241-244

partitioning key, 244

pass-through functions, 136-138

PatIndex() function, 128

performance, of distributed systems, 255

permissions, 544-546

assigning, 556-559

pessimistic locking, 443

plan cache, 639

precision, 61

principals, 540-541

private temporary stored procedures. See temporary stored procedures

procedure cache, 639

Profiler, 12

programs, running, 598-599

property management, 467-470