943 reputation
716
bio website
location Orem, UT
age
visits member for 3 years, 6 months
seen May 13 at 22:08

Adobe Certified Expert - CQ Component Developer


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.
Jan
21
asked Obtaining gratis copy of the SQL specification?
Jan
20
comment Which collation should I choose for a muiti-language website?
Thanks - I thought there were some of the Han characters or the like that were not supported in UTF-8, good to have a solid answer.
Jan
20
comment Traversing tree-like data in a relational database using SQL
Great point, Jeremiah
Jan
13
comment Is there a performance gain by handling data with stored procedures versus feeding it into functions after retrieval?
An excellent point about the optimizer.