968 reputation
819
bio website
location Orem, UT
age
visits member for 3 years, 10 months
seen Aug 31 at 19:59

Adobe Certified Expert - CQ Component Developer


Jun
11
answered SQL database backups methods-tools-procedures
Jun
8
awarded  Constituent
Jun
8
awarded  Caucus
Jan
24
comment What patch(es)/feature(s) to Oracle provide the column avg_hard_parse_time on v$sqlstats?
@Phil "Timed OS Statistics" is off, but "Timed Statistics" is on; would that explain it?
Jan
24
comment What patch(es)/feature(s) to Oracle provide the column avg_hard_parse_time on v$sqlstats?
@LeighRiffel The column simply does not exist.
Jan
18
asked What patch(es)/feature(s) to Oracle provide the column avg_hard_parse_time on v$sqlstats?
Jan
5
awarded  Yearling
Nov
28
comment Role problem of PostgreSQL
ach! Ya beat me! :D
Nov
28
answered Role problem of PostgreSQL
Aug
24
comment What makes an Oracle Applications DBA different from an Oracle DBA?
That's correct - you need to be both a skilled Oracle DBA, as well as have a good knowledge of the particulars of their ERP. You can probably "get there" if you are an Apps DBA, but it's not trivial by any means.
Aug
23
answered What makes an Oracle Applications DBA different from an Oracle DBA?
Aug
23
awarded  Critic
Aug
23
comment Fetch first 9 records and make one more record which will be as “Others” in MySQL
MySQL does not support the 'WITH' clause, or CTE's (see this MySQL bug. You'll need to move this to being an inline view instead.
Aug
23
comment Tools to migrate from SQLite to PostgreSQL
I have existing ETL jobs using Petaho's Kettle that do EXACTLY what this question is asking. It took a few weeks to get the job running really smoothly and setup good error-handling, but it's been running well for almost 2 years now.
Aug
23
answered How to make iSQL/FreeTDS behave like a normal client?
Aug
11
comment How to traverse a tree in SQL? Sybase edition
Both Celko's book and closure tables (mentioned in my response to the original question) are usable in Sybase; for your specific problem, you might also consider using path enumeration (I don't have a handy reference to that one, but a bit of Googling should pay off).
Aug
10
awarded  Nice Answer
Aug
9
awarded  Nice Answer
Apr
25
accepted Which database engines will allow me to GRANT/REVOKE on a specific column?
Jan
24
comment Obtaining gratis copy of the SQL specification?
I appreciate the input - I am actually already comfortable with the engine-specific dialects of most of the popular engines out there, and wanted to branch out to understanding which parts of those engine-specific dialects are actually part of the standards, and which parts are not.