P

Index

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Y] [Z]

PageNavigation event
parameter-based queries
     access rights and
     ad hoc queries, inserting
     best practices
     default parameter values
     duplicate parameter names
     dynamic SQL
     marking parameters
     NULL values
     parameter-based updates
     Parameters collections
    query parameters
         adding
         capturing
         definition of
     SELECT queries
     SqlParameter class
     SqlParameterCollection class
     Unicode literals
    validation
         overview of
         sample application
     Value property
     what can be parameterized
parameters
    queries [See parameter-based queries.]
     report parameters
         creating
         definition of
         sample application
Parameters collections
Parameters property (SqlCommand object) 2nd
parent/child relationships
     updating
Parse function 2nd
Password keyword
passwords, System Administrators
patches
percent sign (%)
performance
     CLR executable performance, evaluating
         overview of
         with SQL Profiler
         stored procedures
         TVFs (table-valued functions)
         UDTs (user-defined types)
     connection pools
    DBMSs
         .NET Framework
         acceptable speed
         ADO
         DAO
         developer performance
         JET
         MDAC stack, sharing
         overview of
         performance metrics
         shareable and reusable components
         shared code
         team development
    performance counters
         activating
         selecting 2nd
         SqlClient performance counters
         viewing with Server Explorer
     Query plans
     SQL Server Express Edition 2nd
performance counters
     activating
     selecting
     SqlClient performance counters
     viewing with Server Explorer
PerformBack method
permissions, denying
Persist Security Info keyword
persistent connections 2nd
personas (security)
pick lists, prompting with
PID (process identifier)
plans, Query [See Query plans.]
polling
pools [See connection pools.]
populating data structures
     DataSet Load method
     DataSets with DataTable objects
     DataTable Load method
     design
     hard-coding DataTable objects
     InfoMessage messages
     OUTPUT and RETURN value parameters
     overview of
     resultset elements 2nd
     SqlDataAdapter Fill method
ports
Position property (BindingSource class) 2nd
PositionChanged event
Prepare method 2nd
PRIMARY KEY constraint
primary keys
     changing
     defining
     GUIDs (globally unique identifiers)
     multi-column primary keys
     PRIMARY KEY constraint
     primary key/foreign key relationships
Print event
Privacy Act of 1974
prjSampleVSReport application
     adding to project
     laying out
procedures, stored [See stored procedures.]
ProcessingMode property (Report Viewer class)
ProductByProfit report
     Data Sources, creating
     formatting
         background color
         expressions
     laying out
     Report Viewer control configuration
     testing
Professional Edition (Visual Studio)
Profiler [See SQL Profiler.]
projects
     adding reports to
     specifications
PromptAreaCollapsed property (Report Viewer class)
prompting
     for parameter values
     with pick lists
properties [See specific properties.]
protection [See security, application design.]
protocols
     Named Pipes
     Shared Memory
     TCP/IP (Transmission Control Protocol/Internet Protocol)
     VIA (Virtual Interface Adaptor)