1,911 reputation
732
bio website
location Ottawa.Ontario, Canada
age 56
visits member for 3 years, 5 months
seen 18 hours ago

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


Jan
17
wiki created active-directory description
Jan
17
wiki created active-directory excerpt
Jan
17
suggested approved edit on active-directory tag wiki
Jan
17
suggested approved 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 approved edit on Why is SQL Server using a clustered index scan for a self referencing FK cascade delete
Jan
17
suggested approved 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
Jan
10
comment Oracle 11g Rel 2 installation on windows 2008 Server
You have to help me before I can help you. What does the log say? Quote the exact error message.
Jan
10
comment Oracle 11g Rel 2 installation on windows 2008 Server
look in C:\app\product\11.2.0\dbhome_1\YourServerName.YourDomain_YourDatabaseName\sysman‌​\log for emagent.log and emagent.trc
Jan
10
comment Oracle 11g Rel 2 installation on windows 2008 Server
can you show us the install log? I would not assume that just because you get an error when starting Enterprise manager that there is a bug in the software.
Jan
8
comment Log File over 400gigs…need to bring this database back to life
Have you considered that maybe this is a job for someone with more experience? It's not fair to you to try and fix up what appears to be a series of omissions. If you succeed then they will expect miracles again and if not then you get the blame....
Dec
16
revised Applying data changes from one database to another
expanded answer
Dec
16
answered Applying data changes from one database to another
Dec
16
comment Applying data changes from one database to another
I'm not clear on the idea of importing data from the development database into production. This seems to break the point of having production and development. What kind of data is this? New properties or characteristics or user entered data?
Dec
13
revised Does Oracle 10g Express Edition have enough storage?
added 6 characters in body