943 reputation
715
bio website
location Orem, UT
age
visits member for 3 years, 3 months
seen Mar 27 at 14:51

Adobe Certified Expert - CQ Component Developer


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?
Jan
24
comment What patch(es)/feature(s) to Oracle provide the column avg_hard_parse_time on v$sqlstats?
@LeighRiffel The column simply does not exist.
Jan
18
asked What patch(es)/feature(s) to Oracle provide the column avg_hard_parse_time on v$sqlstats?