I've worked with both, and in the specific case of running Remedy, I personally prefer SQL Server. Part of it may be due to the out of the box case insensitivity, the easier to use interfaces (I have done Microsoft-based development and taken several SQL Server DB classes in the past.) We use SQL Server in clustered environments with good size data and transaction requirements so while I wouldn't try to run Facebook on it (or Oracle for that matter), it should be no problem whatsoever for any size Remedy system. Both Oracle and SQL Server are extremely stable, the only times I've seen problems are due to things outside of the database engine itself.
Overall, I think you're comparing Florida oranges to California oranges, where both are good and the answer comes down to a selection of personal experience. Thanks, Shawn Pierson Remedy Developer | Energy Transfer From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Tauf Chowdhury Sent: Wednesday, September 05, 2012 3:43 PM To: [email protected] Subject: Oracle vs. SQL ** All, To those of you who have run Remedy on both Oracle and SQL DB, do you have a preference as to which is better/stable/faster etc..? I know SQL has come a long way. Any opinions are welcome. -- Tauf Chowdhury _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ Private and confidential as detailed here: http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the link, please e-mail sender. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
