No performance hits in Oracle if you follow my post: http://theremedyforit.com/2011/12/case-insensitive-in-remedy/
Jose M. Huerta Project Manager** Movil: 661 665 088 Telf.: 971 75 03 24**** Fax: 971 75 07 94**** <http://www.sm2baleares.es/>**** SM2 Baleares S.A. C/Rita Levi **** Edificio SM2 Parc Bit**** 07121 Palma de Mallorca**** <http://es-es.facebook.com/pages/SM2-Baleares/158608627954> <http://twitter.com/#!/SM2Baleares> <http://www.linkedin.com/company/sm2-baleares> La información contenida en este mensaje de correo electrónico es confidencial. La misma, es enviada con la intención de que únicamente sea leída por la persona(s) a la(s) que va dirigida. El acceso a este mensaje por otras personas no está autorizado, por lo que en tal caso, le rogamos que nos lo comunique por la misma vía, se abstenga de realizar copias del mensaje o remitirlo o entregarlo a otra persona y proceda a borrarlo de inmediato.**** P Por favor, no imprima este mensaje ni sus documentos adjuntos si no es necesario. On Wed, Feb 29, 2012 at 06:04, Brian Pancia <panc...@finityit.com> wrote: > ** > > Dave,**** > > ** ** > > Sorry. I wasn't trying to come across as comparing which is better, but > after re-reading my post it doesn't directly answer your question. I have > not found any major gotchas with MS SQL. Oracle case sensitivity has > always been an issue. You can set flags at the db level to change that, > but then you are risking performance hits.**** > > ** ** > > Tommy,**** > > ** ** > > I have seen some issues with how FTS performs certain searches like > wildcard searches. It's been a few months since I've messed with FTS. > I'll see if I can dig up my notes from an installation we did that we ended > up doing a bunch of tweaks to FTS. FTS has been around for a long time > now, so I'm sure a bunch of people can chime in on FTS tips and tricks.*** > * > > ** ** > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *Shellman, David > *Sent:* Tuesday, February 28, 2012 4:57 PM > > *To:* arslist@ARSLIST.ORG > *Subject:* Re: MS SQL question**** > > ** ** > > ** **** > > Brian,**** > > ** ** > > I understand. As I said I'm not asking which is better. I'm attempting > to understand if there are any hidden gotchas with MS SQL like there is > with Oracle.**** > > ** ** > > There my not be any but that is what I want to identify.**** > > ** ** > > Thanks**** > > Dave > > On Feb 28, 2012, at 4:51 PM, "Brian Pancia" <panc...@finityit.com> wrote:* > *** > > ** **** > > Dave,**** > > **** > > Case Sensitivity is not an issue with MS SQL. Also with 7.6.04 you have > FTS, which provides better search capabilities for both Oracle and SQL. In > my opinion MS SQL has come a long way in the last few releases and can > stand up to Oracle as a true enterprise solution. I think a few years ago > there were some valid reasons to go Linux(or flavor of Unix)/Oracle. > Microsoft has come a long way though from both the OS and DB side of the > house. I think now it just depends on the level of onsite expertise for > your DB. I have set up multiple systems on both Oracle and MS SQL over the > years and these days I find it much easier to go the Microsoft route. Both > are rock solid if configured properly. If you have FTS configured properly > it does relief some of the Oracle constraints, but it is something > additional you would have to manage.**** > > **** > > Brian**** > > **** > > *From:* Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] *On Behalf Of *Shellman, David > *Sent:* Tuesday, February 28, 2012 2:00 PM > *To:* arslist@ARSLIST.ORG > *Subject:* MS SQL question**** > > **** > > ** **** > > I know that there are a couple of short comings with running the AR System > on Oracle. Namely case sensitivity and searching a large character field. > I'm wondering if there are short comings running on MS SQL. Not really > looking for a debate on the advantages of one over the other. Just looking > to see if MS SQL has any similar peculiarities.**** > > **** > > Thanks**** > > Dave**** > > **** > > *Dave Shellman** > *+1 717 810 3687 tel > +1 717 810 2124 fax > dave.shell...@te.com**** > > **** > > MS 161-043 > PO Box 3608 > Harrisburg, PA 17105-3608**** > > > <image001.gif> <http://www.te.com/>**** > > **** > > <image002.png> > <http://twitter.com/teconnectivity><image003.png><http://www.facebook.com/teconnectivity> > <image004.png> <http://www.flickr.com/photos/teconnectivity/> > <image005.png> > <http://www.linkedin.com/groups?gid=1591657><image006.png><http://www.youtube.com/teconnectivity> > **** > > **** > > _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ **** > > _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_**** > > _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ **** > _attend WWRUG12 www.wwrug.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"
<<image004.jpg>>
<<image002.jpg>>
<<image003.jpg>>
<<image001.jpg>>
