Brian, I do understand the gotchas of using Oracle. We had been on Oracle in a Solaris and now a Windows environment for about 16/17 years. The Performance Tuning class many years ago taught a lot about how the AR System works at the Oracle level and tying the pieces and parts together.
Thanks for your answer on MS SQL. Dave ________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Brian Pancia Sent: Wednesday, February 29, 2012 12:05 AM To: [email protected] Subject: Re: MS SQL question ** 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:[email protected]] On Behalf Of Shellman, David Sent: Tuesday, February 28, 2012 4:57 PM To: [email protected] 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" <[email protected]<mailto:[email protected]>> 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:[email protected]]<mailto:[mailto:[email protected]]> On Behalf Of Shellman, David Sent: Tuesday, February 28, 2012 2:00 PM To: [email protected]<mailto:[email protected]> 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 [email protected]<mailto:[email protected]> 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<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com<http://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"
