June 4, 2012 at 6:12 pm
I appreciate all the responses to my question, especially the Attunity connector which I will need to investigate.
My thought question: Have you ever been told that your query runs too fast?
My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.
Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St
June 4, 2012 at 11:08 pm
dwain.c (6/4/2012)
I appreciate all the responses to my question, especially the Attunity connector which I will need to investigate.
Attunity is the way to go. It is as far as I know the only free adaptor that achieves high writing to Oracle.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 5, 2012 at 7:47 am
Koen Verbeeck (6/4/2012)
dwain.c (6/4/2012)
I appreciate all the responses to my question, especially the Attunity connector which I will need to investigate.Attunity is the way to go. It is as far as I know the only free adaptor that achieves high writing to Oracle.
I've tested it against both the MS connector for Oracle and T-SQL openquery. I like its speed and it has the fewest problems with connecting, security and speed of use.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply