968 reputation
819
bio website
location Orem, UT
age
visits member for 3 years, 10 months
seen 12 hours ago

Adobe Certified Expert - CQ Component Developer


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.
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.
Jan
10
awarded  Quorum
Jan
10
awarded  Beta
Jan
9
awarded  Commentator
Jan
9
comment Are there any database engines which will intuit the join condition based on the existing foreign keys?
I know none of the common RDBMSes do this - as the question states, I put the question out there to see if anyone had heard of anything new in this area.
Jan
7
comment Which database engines will allow me to GRANT/REVOKE on a specific column?
I just realized this should be a "community wiki" question, but I don't have enough rep to make it so...
Jan
7
asked Are there any database engines which will intuit the join condition based on the existing foreign keys?
Jan
7
asked Which database engines will allow me to GRANT/REVOKE on a specific column?
Jan
7
comment Is there a good “rule of thumb” for translating EXPLAIN cost to (wall-clock) runtime?
Yeah, I figured this was the answer, I just thought there might be a really soft rule that could be used...but thanks for confirming. :)
Jan
7
comment Is there a good “rule of thumb” for translating EXPLAIN cost to (wall-clock) runtime?
Good explanation of how CBO numbers were based. Thanks!
Jan
7
awarded  Scholar
Jan
7
accepted Is there a good “rule of thumb” for translating EXPLAIN cost to (wall-clock) runtime?
Jan
5
awarded  Student
Jan
5
answered Guid vs INT - Which is better as a primary key?