Congratulations

The connectstring seems to be wrong (MSORA are the old MS oracle drivers).

Should be something like

Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=myUsername;

Password=myPassword;

More info on the connectstring[/url]

It's a bit difficult without a testcase (tablescript, indexscript, data).

Points of interest:

The use of distinct bo.MedRecReviewID : why distinct

The inner joins in the upper select: can be replaced with...

No holiday either, next one is in july.

You will be needing the connect information for a linked server configuration.

In-house it would be through OracleOleDb and an Oracle Client on the MS SQL Server.

For within the instance you can use resource governor[/url]

For multiple instances you'll probably go with cpu affinity per instance

You downloaded the 64-bit version

You might want the 32-bit version (X86)

instead of ToString("MM/dd/yyyy")

you can add the hours, minutes ...

ToString("MM/dd/yyyy hh:mi:ss")

*Have yet to lookup the correct formatting string

Haven't worked with TLS 1.2 yet but there is an update to 2012 SP3 to handle TLS 1.2 support

Planning to update 2012 is to service pack 3 Cumulative update 2...

The most exciting part for us is the revamped reporting services and Query Store

wow, nice

Use the proper datetype date to compare dates.

SELECT TO_DATE('07-Feb-2015','DD-MON-RRRR'),sysdate

from dual

where TO_DATE('07-Feb-2015','DD-MON-RRRR')<sysdate;

OR

SELECT TO_DATE('07-Feb-2015','DD-MON-RRRR'),sysdate

from dual

where MYDATE<TRUNC(TO_DATE('07-Feb-2015 15:00:00','DD-MON-RRRR HH24:MI:SS'));

*if you use date(time)parameters the TO_DATE isn't necessary

To get 7 februari

SELECT ...

FROM ...

WHERE...

Thanks for the e-book

Not sure.

I usually go with the TNS-alias of the oracle server, with the servername and port in tnsnames.ora.

Does the proxy user has access to the tnsnames/oracle client?