968 reputation
819
bio website
location Orem, UT
age
visits member for 3 years, 11 months
seen Nov 26 at 1:32

Adobe Certified Expert - CQ Component Developer


May
13
comment Traversing tree-like data in a relational database using SQL
It is my experience that it's far more common to be handed a set of tables in a "naive tree" schema and have to figure out how to extract the correct tree from that storage, than it is to have an opportunity to create the cleaner "closure tables" structure.
Dec
10
comment How do you document your databases?
@CarolBakerWest The question wasn't so much about file formats, but rather "What content goes into such a thing"
Sep
25
comment Why does Oracle hang on “ALTER TABLE ADD … NOT NULL”?
@VincentMalgrat Yes
Sep
25
comment Why does Oracle hang on “ALTER TABLE ADD … NOT NULL”?
@ik_zelf: No FKs or other referential constraints to any other tables
Sep
25
comment Why does Oracle hang on “ALTER TABLE ADD … NOT NULL”?
@Phil: here were previously a large number of rows in the table, but these were removed by a "TRUNCATE TABLE" (which should have reset the HWM, unless I'm mistaken).
Aug
27
comment Obtaining gratis copy of the SQL specification?
While I appreciate the recommendation, and I do love to read Date & Darwen, this book isn't really relevant to the question; it's not available gratis, it doesn't cover the entire specification, and what it does cover has been superseded for more than a decade.
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.
Nov
28
comment Role problem of PostgreSQL
ach! Ya beat me! :D
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
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
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).
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
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.
Jan
11
comment How do you document your databases?
I'm curious to see what "database documentation" even looks like, aside from the obvious schema diagram. I have trouble envisioning what you would document and how.
Jan
11
comment Which database engines will allow me to GRANT/REVOKE on a specific column?
Thanks, Peter - I don't have a copy of the specification, so I wasn't sure if it was covered there. I do happen to know that Firebird nee Interbase does NOT support this, and last time I tried it in MySQL, it didn't work (admittedly, that was a while ago in MySQL terms).
Jan
11
comment Are there any database engines which will intuit the join condition based on the existing foreign keys?
No real "concern", just wondering if this is something anyone is looking into addressing.