Re: Know 1 database, know them all?

2003-02-20 Thread Bjørn Engsig
There seems to be something that you miss in this discussion:  Writing applications! It's very likely very true, that you can use your DBA skills from one database and apply them on another, but many application developers have truely failed to understand that the different databases are very

Re: Know 1 database, know them all?

2003-02-19 Thread Mogens Nørgaard
PROTECTED]] Sent: dinsdag 18 februari 200321:19 To: Multiple recipients of list ORACLE-L Subject:Re: Know 1 database, know them all? Not quite true, as faras I know There's wait stuff in there, although not enough to my taste.There's cpu in there,

RE: Know 1 database, know them all?

2003-02-18 Thread Broodbakker, Mario
e way..You should write a SQLserver paper on that!   Mario -Original Message-From: Mogens Nørgaard [mailto:[EMAIL PROTECTED]]Sent: dinsdag 18 februari 2003 21:19To: Multiple recipients of list ORACLE-LSubject: Re: Know 1 database, know them all?Not quite true, as far as I

RE: Know 1 database, know them all?

2003-02-18 Thread Post, Ethan
recipients of list ORACLE-LSubject: Re: Know 1 database, know them all?Not quite true, as far as I know There's wait stuff in there, although not enough to my taste. There's cpu in there, and the start and stop time, which makes it possible to at least make a crude R = S + W,

Re: Know 1 database, know them all?

2003-02-18 Thread Mogens Nørgaard
Not quite true, as far as I know There's wait stuff in there, although not enough to my taste. There's cpu in there, and the start and stop time, which makes it possible to at least make a crude R = S + W, where the difficult part is breaking down the W into meaningful stuff. A long way to

Re: Know 1 database, know them all?

2003-02-18 Thread Anjo Kolk
Actually there are wait stats in SQL server that you can only see with Precise Indepth for SQLServer ;-) "Broodbakker, Mario" wrote: > > Mogens, the only problem with your statement about 'oracle myths & king of the new >world' is that the only way of looking at SQLServer performance is probabl

Re: Know 1 database, know them all?

2003-02-18 Thread Mogens Nørgaard
Yeah, that could be :). OK, OK: Angle, angle, angle, angle. Undskyld. Best regards, The Oracle Angels of Denmark (TOAD) Orr, Steve wrote: RE: Know 1 database, know them all? > I see it from a slightly different (and probably wrong) angel  Angel? Hmmm... is tha

RE: Know 1 database, know them all?

2003-02-18 Thread Stephen Lee
Perhaps a philosophical discussion is in order on the roles of Right Angels versus Obtuse Angels versus Acute Angels. I would hypothesize that Right Angels occupy the uppermost regions of Heaven. Obtuse Angels, being obtuse and mentally slow, are responsible for the enforcement of Murphy's Law.

RE: Know 1 database, know them all?

2003-02-18 Thread Broodbakker, Mario
Mogens, the only problem with your statement about 'oracle myths & king of the new world' is that the only way of looking at SQLServer performance is probably looking at ratio's: there are no wait statistics, there is one(1) latch wait counter though! for the complete system :( (apart from some

RE: Know 1 database, know them all?

2003-02-18 Thread Orr, Steve
Title: RE: Know 1 database, know them all? > I see it from a slightly different (and probably wrong) angel  Angel? Hmmm... is that a veiled reference to the satanic dark side Luke? -Original Message- From: Mogens Nørgaard [mailto:[EMAIL PROTECTED]] Sent: Monday, February 17, 2

Re: Know 1 database, know them all?

2003-02-17 Thread Lyndon Tiu
Learning the first database is the hardest for me. After which learning the rest was easy. -- Lyndon Tiu Quoting Mogens Nørgaard <[EMAIL PROTECTED]>: > I see it from a slightly different (and probably wrong) angel, at > least > regarding the performance of things and databases: If you've work

Re: Know 1 database, know them all?

2003-02-17 Thread Mogens Nørgaard
I see it from a slightly different (and probably wrong) angel, at least regarding the performance of things and databases: If you've worked with Oracle databases for some time (and have real experience), and know about the myths and their anti-thesis (use the wait interface instead of the ¤&#%

Re: Know 1 database, know them all?

2003-02-17 Thread Ferenc Mantfeld
Following the same logic. if I learn to cook a good Italian dish, then I must automatically be an expert in preparing top-class Chinese, German, Malay, Hungarian and French cuisine Yeah, right ! Ferenc Mantfeld Dreaming costs you nothing. Not dreaming costs you everything. - Original

RE: Know 1 database, know them all?

2003-02-17 Thread Richard Ji
Maybe both, LOL. Oracle, DB2, Sybase etc are all archetecturly different. You HAVE to learn each one of them. With Informix, even their OLTP and DW products are two different animals. -Original Message- Sent: Monday, February 17, 2003 5:29 AM To: Multiple recipients of list ORACLE-L Ei

Re: Know 1 database, know them all?

2003-02-17 Thread Les Ayudo
LOL!! Thanks for replies guys. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, February 17, 2003 2:28 AM > Either the person knows sybase and SQL Server or the drugs kicked in. Much of the theory is similar but there are enough difference

RE: Know 1 database, know them all?

2003-02-17 Thread Farnsworth, Dave
Either the person knows sybase and SQL Server or the drugs kicked in. Much of the theory is similar but there are enough differences that only RTFMing and experience can help. I do SQL Server, Oracle and now am learning DB2. They all claim to be ANSI92 compliant. The problem is that they eac

Re: Know 1 database, know them all?

2003-02-16 Thread Anjo Kolk
It depends on the level you are looking at it. From a high level, every database does PIO (read/write data to disk), then from the buffer cache (global/local) it does do LIO (accessing buffers). Access to these buffers is synchronized (latching/locking not only on buffers but also on a higher l

Re: Know 1 database, know them all?

2003-02-16 Thread Markus Reger
hello general guideline the SQL language is (almost) the same standardized one everywhere. BUT not everything is always implemented yet everywhere. e.g.: storing binary objects, stored procedures, java vm, sql*plus,storing java procedures (obfuscated or not) ... e.g.: conceptual differences

Re: Know 1 database, know them all?

2003-02-15 Thread david davis
Must have been basic theory or perhaps they were referring to ANSI SQL which we all use. You will find substantial differences between UDB, DB2/MVS, Oracle and SQL Server and all the others. I have worked at one time or another with the above mentioned and moving from one to another was fairly