Object Browser
debugging stored procedures, 58
inspecting in-built functions, 181
object ownership
DBO owning objects, 229
compared to alternative, 229
security problems, 229
parts of named object, 228
permissions issues, 228
sp_changeobjectowner system stored procedure, 228
object permissions
DENY action, 226
GRANT action, 226
permissions issues, 226
REVOKE action, 226
syntax, 226
OBJECTPROPERTY
checking if function is deterministic or not, 182
objects
tracing object creation and deletion, 168
Open method
SqlConnection class, 117
OPEN statement
accessing cursors from code, 70
operator cost
execution plan, 45
OPTIMISTIC
updatability of cursor, 69
optimistic locking
coding for integrity and concurrency, 101
logical unit of work, 101, 106
reasons for preferring, 108
row based scheme, 101, 102
checking all fields, 102
date-time column, 102
timestamp column, 102
unchecked scheme, 101
optimizing stored procedures, 35
see also high performance stored procedures.
dynamic SQL in stored procedures, 50
execution plan, 38
cost, 44
stored procedure execution plan, 42
understanding execution plan, 44
SET NOCOUNT ON option, 35
example of using, 37
WITH RECOMPILE clause, 37
reasons for using, 38
OS (Operating System) issues
concurrency, 92
Outlook
SQL Mail and, 170
OUTPUT method
returning values from stored procedures, 29
OUTPUT parameter
XP_FileExists system stored procedure, 163
overflows
SQL buffer overflow, 243