TML

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

	888 reputation	bio	website		visits	member for	2 years, 4 months
613 badges		location	Orem, UT		seen	May 14 at 13:45

summary answers questions tags badges favorites bounties reputation activity

29 Comments

suggestions reviews revisions comments badges posts accepts all

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).
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.
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.
Nov 28	comment	Role problem of PostgreSQL ach! Ya beat me! :D
Aug 24	comment	What makes an Oracle Applications DBA different from an Oracle DBA? That's correct - you need to be both a skilled Oracle DBA, as well as have a good knowledge of the particulars of their ERP. You can probably "get there" if you are an Apps DBA, but it's not trivial by any means.
Aug 23	comment	Fetch first 9 records and make one more record which will be as “Others” in MySQL MySQL does not support the 'WITH' clause, or CTE's (see this MySQL bug. You'll need to move this to being an inline view instead.
Aug 23	comment	Tools to migrate from SQLite to PostgreSQL I have existing ETL jobs using Petaho's Kettle that do EXACTLY what this question is asking. It took a few weeks to get the job running really smoothly and setup good error-handling, but it's been running well for almost 2 years now.
Aug 11	comment	How to traverse a tree in SQL? Sybase edition Both Celko's book and closure tables (mentioned in my response to the original question) are usable in Sybase; for your specific problem, you might also consider using path enumeration (I don't have a handy reference to that one, but a bit of Googling should pay off).
Jan 24	comment	Obtaining gratis copy of the SQL specification? I appreciate the input - I am actually already comfortable with the engine-specific dialects of most of the popular engines out there, and wanted to branch out to understanding which parts of those engine-specific dialects are actually part of the standards, and which parts are not.
Jan 20	comment	Which collation should I choose for a muiti-language website? Thanks - I thought there were some of the Han characters or the like that were not supported in UTF-8, good to have a solid answer.
Jan 20	comment	Traversing tree-like data in a relational database using SQL Great point, Jeremiah
Jan 13	comment	Is there a performance gain by handling data with stored procedures versus feeding it into functions after retrieval? An excellent point about the optimizer.
Jan 11	comment	How do you document your databases? I'm curious to see what "database documentation" even looks like, aside from the obvious schema diagram. I have trouble envisioning what you would document and how.
Jan 11	comment	Which database engines will allow me to GRANT/REVOKE on a specific column? Thanks, Peter - I don't have a copy of the specification, so I wasn't sure if it was covered there. I do happen to know that Firebird nee Interbase does NOT support this, and last time I tried it in MySQL, it didn't work (admittedly, that was a while ago in MySQL terms).
Jan 11	comment	Are there any database engines which will intuit the join condition based on the existing foreign keys? No real "concern", just wondering if this is something anyone is looking into addressing.
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.