Case insensitive searches can perform very slows and can cause performance bottleneck at the remedy application layer as case insensitive queries may cause full table scan over unique index scan, I would go for Oracle.
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of David Durling Sent: Friday, September 28, 2012 8:06 PM To: arslist@ARSLIST.ORG Subject: Re: SQL or Oracle There was a recent discussion on this, if you check out the list archives. I'm not a dba, but one thing I'm looking forward to with MS SQL, if we move to it from Oracle, is the case-insensitive searching without having to do any special setup on the db side. David David Durling University of Georgia > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W > Sent: Friday, September 28, 2012 10:25 AM > To: arslist@ARSLIST.ORG > Subject: Re: SQL or Oracle > > Oracle is not bad either. Usually I ask what does your company support > most. If you have better people for Oracle then choose Oracle, same goes > for MS-SQL. > > Fred > > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Cook > Sent: Friday, September 28, 2012 9:22 AM > To: arslist@ARSLIST.ORG > Subject: Re: SQL or Oracle > > ** > The question I find most relevant is what platform your organization has the > resources to support. Most of us can handle most day to day MSSQL > tasks. Not so with Oracle, which requires someone trained and experienced. > Rick > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of Hennigan, Sandra > Sent: Friday, September 28, 2012 9:08 AM > To: arslist@ARSLIST.ORG > Subject: SQL or Oracle > > All, > > I am setting up a brand new ARS with ITSM. The big decision is whether to go > with SQL or Oracle as the backend. > > I prefer SQL; management thinks Oracle. > > Without starting a frightening Friday foray on the List, does anyone (LOL) on > the list have an opinion? I really need some feedback with the Pros & Cons of > using either DB that I can take to my managers. > > So you know, the system is for an organization that will support about 3000 > end users (Support staff plus customers). We have the entire ITSM suite to > deploy which will be accomplished in stages. We will start with Asset and > Incident Management then move onto Change and Release then to SRM. > > Anyone? > > Thank you, > > Sandra Hennigan > Remedy Developer > > __________________________________________________________ > _____________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 > www.wwrug12.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
