TML

less info
meta site favicon meta user | stack exchange network profile network profile
888 reputation
613
bio website
location Orem, UT
age
visits member for 2 years, 4 months
seen May 14 at 13:45
stats profile views 43

Nothing useful here


64 Actions

suggestions reviews revisions comments badges posts accepts all
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?
Jan
5
 comment Which collation should I choose for a muiti-language website?
The new title reads much better
Jan
5
 awarded  Teacher
Jan
5
 answered Is it possible to use SQLite as a client-server database?
Jan
5
 comment When to use NULL and when to use an empty string?
+1 for pointing out this Oracle oddity...this was a HUGE "WTF" moment for me when I first started dealing with Oracle databases.
Jan
5
 asked Is there a good “rule of thumb” for translating EXPLAIN cost to (wall-clock) runtime?
Jan
5
 comment How can a group track database schema changes?
+1 for spreading this blog post - a good starting point for many organizations!
Jan
5
 answered How can a group track database schema changes?
Jan
5
 comment Traversing tree-like data in a relational database using SQL
I agree with your conclusion - however, I haven't seen a lot of good information on using HIERARCHYID - if you could improve this answer a bit by digging up a relevant link, I'd gladly +1 this answer.
Jan
5
 answered Traversing tree-like data in a relational database using SQL
Jan
5
 answered Is there a performance gain by handling data with stored procedures versus feeding it into functions after retrieval?
1 2 3 4