page locks, 93
PAGLOCK hint, 95
parameters
return parameters in error handling, 56
stored procedures, 18, 20, 131
avoiding too many parameters, 132
matching input and ouput parameters, 31
Parameters collection
compared to REPLACE() function, 238
sp_executesql system stored procedure, 237, 238
SQL injection attack solutions, 237
password column
sysxlogins table, 224
passwords
attacking with PWDCOMPARE() function, 224
comparing with PWDCOMPARE() function, 224
generating random password, 223
sa password, 223
pausing execution
flow control of stored procedures, 26
SQL Server Agent, 26
WAITFOR() function, 26
performance tuning
administration and stored procedures, 120
permissions issues
database objects, 225
group accounts, 223
guidelines for setting permissions, 231
login ID's, 224
object ownership, 228
object permissions, 226
roles, 227
SQL injection attacks, 239
SQL Server Debugger, 58
SQL Server security vulnerabilities, 223
statement permissions, 226
user accounts, 223
user ID's, 225
pessimistic locking
coding for integrity and concurrency, 100
phantom rows, 97
port 1433
security problems, 221
POWER() function
COLUMNS_UPDATED test, 206
procedure execution article
serializable procedure execution article, 13
stored procedures and replication, 13
PUBLIC role, 227
advantages of removing, 228
SQL injection attacks, 239
pubs example database
restoring to default condition, 31
PWDCOMPARE() function
attacking passwords, 224
comparing passwords, 224
PWDENCRYPT() function
SQL buffer overflow, 243