I believe you will need software assurance for the downgrade (2014->2012) rights.

"Number" are actually NVARCHAR(768)

->SQLServer does that when there is no precision and scale specified in Oracle

VARCHAR2 columns are returned as NVARCHAR (at least the length is OK)

->Depends on the Oracle...

Close to 100%.

Congratulations on passing the STIg audit

It will be hard to find drivers that connect to Oracle 8i.

Perhaps you could export the database and import it into Oracle 12 and use that as a source for...

The databases were fully backupped once?

Databases are in full/bulk logging mode?

Perhaps there are long running transactions/replications going on

You could convert the maintance plan to a normal job to see what's...

How are you quering Oracle through SSRS?

Using SQLServer as a datasource and using the LINKEDSERVER..SCHEMA.TABLE / OPENQUERY notation

Or Using Oracle as a datasource?

Is it possible to post the query?

Waittypes of the queries (IO/NETWORK/CXPACKET/...)

Can be done with sp_Whoisactive or the dynamic management views.

MS SQL Server max memory does not include reporting services.

Total memory-MS SQL Server max memory= memory for OS, SSRS, SSAS, SQL Agent, SSIS, other applications

Thanks for the build list.

I'm relying on sqlserverbuilds.blogspot.be[/url] as it has the builds up to SQL 7.

You're welcome

Did you try casting p.TriggerDate >= '06-Nov-2014'

to a date-variable? (instead of relying on strings)

->where p.TriggerDate>=TO_DATE('2014-11-06','YYYY-MM-DD')

Whilst there are people who can soak knowlegde, actually applying certainly helps.

Can't forget about maintaining it, so your brain doesn't purge it.

Oracle Client and the use of OracleOleDB?

MSOra is probably the old deprecated oracle driver

Congratulations Koen, keep writing!