968 reputation
819
bio website
location Orem, UT
age
visits member for 3 years, 9 months
seen Aug 31 at 19:59

Adobe Certified Expert - CQ Component Developer


Sep
24
awarded  Autobiographer
Sep
5
awarded  Nice Question
Aug
17
awarded  Enlightened
Aug
16
awarded  Nice Answer
Jul
2
awarded  Curious
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.
Jan
6
awarded  Editor
Jan
6
revised Guid vs INT - Which is better as a primary key?
added 1 characters in body
Jan
5
awarded  Yearling
Sep
23
awarded  Nice Answer
May
14
awarded  Caucus
Jan
5
awarded  Yearling
Dec
14
awarded  Revival
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).
Sep
24
asked Why does Oracle hang on “ALTER TABLE ADD … NOT NULL”?
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.
Jun
20
awarded  Taxonomist