Fred Hooper
fahooper at trapo.com
Thu May 31 14:53:46 CDT 2007
I work with Cognos BI tools a lot. For reporting, Cognos and other BI tools would work equally well with either Oracle or SQL Server; I've used Cognos with both. There's a lot of logic in putting your data warehouse on a box that isn't serving your transaction database, but there's no reason for the warehouse to be a different manufacturer's database. Therefore, I don't see any need for Oracle for you. Fred Hooper -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Elizabeth.J.Doering at wellsfargo.com Sent: Thursday, May 31, 2007 3:25 PM To: dba-sqlserver at databaseadvisors.com Subject: [dba-SQLServer] SQL Server versus Oracle 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