PROTECTED]
Subject: RE: MS SQL hasn't given up!
Date: Fri, 28 Feb 2003 12:49:29 -0800
no problem Rich. the transaction log mirroring can be done by the DBMS.
and SQueal Server has disk devices much like a tablespace that can be
placed
on different disks and such. transaction logs are kind of like
as
DBMS/OS capabilities was a much harder sell.
From: STEVE OLLIG [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: MS SQL hasn't given up!
Date: Fri, 28 Feb 2003 12:49:29 -0800
no problem Rich. the transaction log
Well, if they are serious about staying in the big db market, they'd better
keep trying. And, where do you catch the attention of managers and
journalists? Show some big commitments to your platform by major companies
or show performance benchmark results that rival or exceed your
competition's.
www.opensource.org and other sites (The Register) and
www.globetechnology.com (Globe Mail's technology news site) mentioned that
MS considers LINUX a threat.
Last week I attended an OS security class where each student had two PCs,
one was a Windows2000 machine, one was a LINUX machine. The
Fresh in memory because 2 days ago I had meeting with MS SQL people from
Microsoft.
I will talk about MS SQL 2000 Enterprise.
1. MS SQL cannot handle exception. There is nothing like EXCEPTION WHEN ...
THEN.
2. MS SQL has nothing like package.
3. MS SQL has nothing like partitioned table
The major misconception is that open source is free (As in no charge, al
la Free beer). This this not the case. It is free, as in you can see
the source code, play with it, and distribute it. However, you need
support, maintenance, etc. This is where the costs are.
My company uses Linux for
Advanced Linux is free, but if you choose to buy prepackaged distribution then
you have to pay for it. But you will find the same software as in
downloaded distribution. :-)
I'm using SuSE workstation for Oracle developing and everyday office work more
than 2 years now and, personally (!), to
)
is to Mirror.
David
From: Jan Pruner [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: MS SQL hasn't given up!
Date: Fri, 28 Feb 2003 07:19:10 -0800
Fresh in memory because 2 days ago I had meeting with MS SQL people from
Not sure if this is true... I heard that to back up the transaction log, the
database has to be stopped.
???
Pat.
-Original Message-
Sent: Friday, February 28, 2003 11:19 AM
To: Multiple recipients of list ORACLE-L
Fresh in memory because 2 days ago I had meeting with MS SQL people
of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: MS SQL hasn't given up!
Date: Fri, 28 Feb 2003 08:59:14 -0800
Not sure if this is true... I heard that to back up the transaction log,
the
database has to be stopped.
???
Pat.
-Original Message-
Sent: Friday, February 28, 2003 11:19 AM
Hi
I saw this list posted on an Oracle Newsgroup a while back :-)
Oracle has multiversioning. SQL Server has no equivalent
In Oracle reads don't block writes and writes don't block reads
In Oracle there are unlimited row level locks
In Oracle there is no such thing as lock escallation or page
the writes to
the transaction logs (redo). DB2/UDB has it. The MSS method (only option)
is to Mirror.
David
From: Jan Pruner [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: MS SQL hasn't given up!
Date: Fri, 28 Feb 2003 07:19
: Re: MS SQL hasn't given up!
Date: Fri, 28 Feb 2003 07:19:10 -0800
Fresh in memory because 2 days ago I had meeting with MS SQL people
from
Microsoft.
I will talk about MS SQL 2000 Enterprise.
1. MS SQL cannot handle exception. There is nothing like EXCEPTION
WHEN ...
THEN.
2. MS SQL has
To: Multiple recipients of list ORACLE-L
Subject: RE: MS SQL hasn't given up!
Yes and no. If your logs are backed up every 30 minutes, then you are
effectively saying that you are willing to lose up to 30 minutes of
transactions, in the event of failure on the TX logs (e.g. hardware).
OTOH
: RE: MS SQL hasn't given up!
Yes and no. If your logs are backed up every 30 minutes, then you are
effectively saying that you are willing to lose up to 30 minutes of
transactions, in the event of failure on the TX logs (e.g. hardware).
OTOH,
Oracle can easily be made to be completely
To: Multiple recipients of list ORACLE-L
Subject: RE: MS SQL hasn't given up!
Steve, when you say mirror are the writes duplicated from SQueaL Server
or
hardware? My DBA instructor had distributed some e-mails from a student
who
left the mirroring of redos up to hardware. One controller
to prove my case. Actually, used application porting time/costs/metrics as
DBMS/OS capabilities was a much harder sell.
From: STEVE OLLIG [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: MS SQL hasn't given up!
Date: Fri, 28
: RE: MS SQL hasn't given up!
Date: Fri, 28 Feb 2003 12:49:29 -0800
no problem Rich. the transaction log mirroring can be done by the DBMS.
and SQueal Server has disk devices much like a tablespace that can be
placed
on different disks and such. transaction logs are kind of like tables
Title: RE: MS SQL hasn't given up!
Select * from dual
/
always gives good performance ...
Okay ... MS got good numbers, so assume that system was so tweaked that no other program else might be running on it for all we know. Launch a local IE and see the TPC-C go down ... (I know
If you know MS. You should know they will never give up. They will
conquer the Universe one day. Resistance is futile.
--
Lyndon Tiu
Quoting DENNIS WILLIAMS [EMAIL PROTECTED]:
For your amusement, MS thinks they can now equal Oracle in
performance
(wasn't that what they claimed 3 years
Title: RE: MS SQL hasn't given up!
I think it is foolish to ignore MS SQL at this point. I think that knowing MS SQL only benefits me as a Oracle DBA in the long-run. It helps to understand the core concepts of managing RDBMS. I don't think I could know both in the same amount of detail
Title: RE: MS SQL hasn't given up!
I
agree - the biggest advantage Oracle has to MS SQL Server is Unix stability to
Windows stability.
-Original Message-From: Jamadagni, Rajendra
[mailto:[EMAIL PROTECTED]Sent: Thursday, February 27,
2003 2:44 PMTo: Multiple recipients
Title: RE: MS SQL hasn't given up!
Paula,
I like the 100% tired part.
Raj
-
Rajendra dot Jamadagni at espn dot
com Any views expressed here are
strictly personal. QOTD: Any clod can
have facts, having an opinion is an art
Title: RE: MS SQL hasn't given up!
I
would be curious to know what changes they made to the OS, what services they
decided not to run.
Did
they follow their own security guidelines before running the
tests?
Pat.
-Original Message-From: Jamadagni, Rajendra
[mailto:[EMAIL
Title: RE: MS SQL hasn't given up!
He's
got a good point, performance at that point doesn't matter if your system
must be rebooted weekly, and crashes every couple of days.
The
tests should be run 24x7 for 350 days... to get a real idea on what kind of
reliability and performance you can
As long as I'm not replaced by an open source (cheap) DBA
Stephane Paquette
Administrateur de bases de donnees
Database Administrator
Standard Life
www.standardlife.ca
Tel. (514) 925-7187
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
-Original Message-
[EMAIL PROTECTED]
Sent:
26 matches
Mail list logo
