[dba-SQLServer] SQL Server versus Oracle

Liz,

I would not consider myself an expert on either...but recently I found a 
distinct advantage that SQL server has over DB2 and informix(possibly oracle 
as well).  I do alot of investigative reporting for our legal department 
where I have to do wild card searches against their 'notes' fields(TEXT 
FIELDS)...and we found that you can NOT do these in DB2 or Informix.  You 
can in SQL Server.

I'm not sure about Oracle...but this simple ability, or lack there of, 
scared the heck out of the legal dept when they could not get their data.

Just a thought to look into.

Mark


>From: <Elizabeth.J.Doering at wellsfargo.com>
>Reply-To: dba-sqlserver at databaseadvisors.com
>To: <dba-sqlserver at databaseadvisors.com>
>Subject: [dba-SQLServer] SQL Server versus Oracle
>Date: Thu, 31 May 2007 14:25:15 -0500
>
>
>Come to find out, I am speaking in 30 minutes about the virtues of SQL
>Server 2005 versus those of Oracle.  Given that my knowledge of Oracle
>could still dance comfortably on the head of a pin, I am frantically
>googling up details for my 'speech', and I would love to have your
>opinions
>
>I can easily say that we have already SQL Server and that Oracle is
>going to cost us $$$$$ that we hadn't budgeted for.  The thing I am most
>up against is a contention that 650 users are going to generate more
>data in a year or two than SQL Server can possibly hold.  I'm of the
>opinion that with a normalized database in a call center environment,
>users generating 10 or 12 records per call can go for years without
>seeing much if any slowdown.  Is this accurate?
>
>Oracle isn't being suggested for the production environment however.
>Oracle is being pushed for the REPORTING side of this system, for the 3
>or 4 analysts who will be looking at the long term performance of the
>folks in the call center.
>
>Is this making sense?  The production staff can live with SQL Server,
>but 3 or 4 analysts need the big bucks spent on Oracle for running their
>reports.
>
>Opinions, please?
>
>
>Thanks,
>
>
>Liz
>
>
>Liz Doering
>elizabeth.j.doering at wellsfargo.com
>612.667.2447
>
>
>This message may contain confidential and/or privileged information. If
>you are not the addressee or authorized to receive this for the
>addressee, you must not use, copy, disclose, or take any action based on
>this message or any information herein. If you have received this
>message in error, please advise the sender immediately by reply e-mail
>and delete this message. Thank you for your cooperation.
>
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>

_________________________________________________________________
PC Magazine’s 2007 editors’ choice for best Web mail—award-winning Windows 
Live Hotmail. 
http://imagine-windowslive.com/hotmail/?locale=en-us&ocid=TXT_TAGHM_migration_HM_mini_pcmag_0507