943 reputation
716
bio website
location Orem, UT
age
visits member for 3 years, 6 months
seen May 13 at 22:08

Adobe Certified Expert - CQ Component Developer


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
Jun
11
answered SQL database backups methods-tools-procedures
Jun
8
awarded  Constituent
Jun
8
awarded  Caucus
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?