Index_P

P

Package locations, managing, 123

Package menu, in DTS Designer, 121

Package versions

deleting, 118

managing, 117-118

Packages

executing, 121-123

executing from command prompt, 122-124

executing from within packages, 129

failing when executed from a job, 125

optimizing, 124-128

saving, 116-117

saving as COM-structured files, 117

saving as VB files, 117

saving locally in SQL Server, 117

saving in Meta Data Services, 117

scheduling, 124

securing, 119-121

PageDefrag, 211

pagefile.sys file, 210-211

Pager e-mail, 104

Pager E-mail Name option, 104

Parse ODBC Messages Prefixes option, 168

Partitioned views. See DPVs

Partitioning data horizontally, 227

Partitions, for clustering, 383, 386

Pass-through queries, 318-320

Password for a user, hacker finding out, 88

Passwords

auditing for blank, 74

changing, 74-75

for SA account, 75-76

storage of, 61

PDC (primary domain controller), 11

Performance

of the database model, 226-232

and increasing memory, 31

Indexed Views and, 333

with RAID 10, 13

of replication, 454

security measures and, 74

snapshot of, 138, 145

of stored procedures, 236-237

testing using sample data, 232-234

of T-SQL, 241-243

using Profiler to tune, 254, 257

Performance alerts, setting, 158-159

Performance baseline, creating, 141-142

Performance counters (System Monitor)

list of, 465-466

to watch, 142-145

Performance logs, viewing, 147

Performance Monitor, 138

Performance Monitor tab (System Monitor), 26, 452

Performance tips for queries, 241-242

Permission-denied errors, auditing of, 72-73

Permissions, 61-71

are cumulative, 61

for registry key access, 82

for starting SQL Server, 15

stored in syspermissions table, 63

Permissions assigned, listing, 474

Per-processor licensing model, 14

Piping a query to a text file, 181

Placeholder values, replacing with real data, 169

Placeholders, 169, 171, 173-174

Point-in-time scenarios, 289-290

Polling a server, 138

Popup messages, sending to a workstation, 104

Ports

changing default, 79-80

unique for each server instance, 378-379

Position functions, 193-194

Pound sign (#), before table name, 238

Power losses, 184

Power management options, 212-213

Power supplies, redundant, 345

Power Users group, 16

Preferred Owners screen (cluster group), 399-400

Preinstallation decisions, 11-14

Primary key constraint, 234

Primary server (log shipping), 348-349, 368

Private connection for clustering, 393-394

Private disk resource (in clustering), 371

Procedure cache, flushing, 236

Processes currently running, list of, 466-467

Processor affinity, and scaling up, 340

Processor licensing model, 14

Processor tab (Properties dialog box), 31

Processor use, managing, 31

Processors per instance, 340

Production DBA (job description), 46-47

Production environment, 53

Profiler (SQL Server), 89, 254-258

ProgramFilesDir data item, 24

Properties, explained, 206

Properties dialog box

Advanced tab, 409-410

Connections tab, 31-32

Database Settings tab, 32

Dependencies tab, 408

General tab Startup Parameters, 34-35

Memory tab, 29-30

Processor tab, 31

Security tab, 33-34

Server Settings tab, 33

Protocol list, TCP/IP on the top of, 213

Protocol vulnerabilities, 79-80

Protocols that connect to SQL Server, 80

Public connection, for clustering, 393

Public role, 66-67

Publications (in replication)

applying filters to, 443-444

creating, 438

defined, 421, 423

Publisher Properties screen, 435

Publisher/distributor replication model, 422

Publisher/distributor/subscriber paradigm, 422

Publishing, selecting objects for, 439

Publishing company example schema, 196-197

pubs database, 23

Pull Subscription Wizard, 447

Pull subscriptions, 423, 447

Push Subscription Wizard, 447, 449

Push subscriptions, 423, 447, 449