1,897 reputation
731
bio website
location Ottawa.Ontario, Canada
age 56
visits member for 3 years, 3 months
seen yesterday

Oracle DBA and programmer with 10 years experience maintaining mission-critical applications. Lots of PL/SQL, C# and the usual glue, vbscript, DOS


Jan
21
revised table wiki description
added 423 characters in body
Jan
21
wiki created table description
Jan
21
wiki created table excerpt
Jan
21
suggested suggested edit on table tag wiki
Jan
21
suggested suggested edit on table tag wiki excerpt
Jan
21
comment 1 time shrink of abused databse or restore from backup
what kind of database, oracle? what version?
Jan
17
revised active-directory wiki description
added 413 characters in body
Jan
17
revised active-directory wiki excerpt
added 142 characters in body
Jan
17
wiki created active-directory description
Jan
17
wiki created active-directory excerpt
Jan
17
suggested suggested edit on active-directory tag wiki
Jan
17
suggested suggested edit on active-directory tag wiki excerpt
Jan
17
revised t-sql wiki excerpt
spelling of Microsoft in excerpt
Jan
17
revised Why is SQL Server using a clustered index scan for a self referencing FK cascade delete
spelling in title
Jan
17
suggested suggested edit on Why is SQL Server using a clustered index scan for a self referencing FK cascade delete
Jan
17
suggested suggested edit on t-sql tag wiki excerpt
Jan
17
comment Changes in Oracle Database implicit conversion rules for select statement
Some developer somewhere should read up on the perils of mixing data types in the same column.
Jan
17
comment Changes in Oracle Database implicit conversion rules for select statement
How about showing us the SQL statement that generates the error?
Jan
13
awarded  Popular Question
Jan
13
comment How to make stored procedures more readable without harming performance
Novick's article was written in 2005. Not being an SQL Server guy I can only assume that there have been positive changes since then in performance for nested subroutines