Viewing 15 posts - 346 through 360 (of 851 total)
[font="Verdana"]:blink:
Last time I looked, the definition of a "constant" was something that was invariant.
Tables vary.
So, not constants.
I agree with many of your (earlier) points about SQL as a language. ...
April 6, 2009 at 2:17 pm
Mike C (4/5/2009)
Oracle is good about implementing new features and functionality really quickly... sometimes they even get their features out to market before the ISO standards updates are approved.
[font="Verdana"]I've...
April 5, 2009 at 10:44 pm
Mike C (4/5/2009)
April 5, 2009 at 10:21 pm
[font="Verdana"]To be frank, in my experience the issues with cursor-based code in Oracle have been concealed by the huge overkill of hardware assigned to Oracle databases. The same database...
April 5, 2009 at 9:46 pm
[font="Verdana"]I bet you hear that from Oracle developers who have never bothered to performance tune their code or bother to learn how to write set-based code.
No. Oracle does not...
April 5, 2009 at 9:24 pm
[font="Verdana"]It puzzles me as well, and I've commented earlier on that. "row-by-row" is just as agonising in Oracle as it is in SQL Server.
About the only thing I can...
April 5, 2009 at 3:00 pm
[font="Verdana"]Thanks for that Bob. Now I have to clean up the mess of my brain exploding all over my monitors![/font]
April 2, 2009 at 8:35 pm
znkin (4/2/2009)
What I understand from your replies is that it would be best to have the identity column for the join rather than the generated...
April 2, 2009 at 8:33 pm
Paul White (4/2/2009)
Bruce,I just wanted to add that a cluster key on an identity column is not without issues.
[font="Verdana"]Hey Paul,
Any design for a large system needs to be tuned for...
April 2, 2009 at 6:43 pm
[font="Verdana"]I agree with Flo.
If you use generated keys (like the integer ID field) rather than "natural keys" or "business keys" (like the Code field), then you can save yourself a...
April 2, 2009 at 3:32 pm
Bob Hovious (4/1/2009)
I've never met Cardinal Reciprocity. Where does he stand in the hierarchy of the SQL Inquisition?
[font="Verdana"]That would be on his head, I believe.[/font]
April 1, 2009 at 3:39 pm
... I was kinda looking forward to enforced tea ceremonies courtesy of our new CEO (Phil Factor).
April 1, 2009 at 3:39 pm
GilaMonster (4/1/2009)
Wikipedia? Link?
[font="Verdana"]Sorry Gail. The Concept of Cardinal Reciprocity- A Primer By Hugh Bin-Haad.[/font]
April 1, 2009 at 3:34 pm
Viewing 15 posts - 346 through 360 (of 851 total)