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


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
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?
Jan
5
comment Which collation should I choose for a muiti-language website?
You might want to rephrase the question so that it doesn't sound so subjective - "best" collation by what measure? :)
Jan
5
answered Which collation should I choose for a muiti-language website?
Jan
5
awarded  Supporter
Jan
5
comment What are the differences between NoSQL and a traditional RDBMS?
Good, exhaustive answer.