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!

Glad you keep the thread awake

Happy Holidays and a fun New Year.

Oracle 9 is really old by now. Maybe you can connect to it if you have the oracle 11g client en the oracle database is at least 9.2.0.4. The 12c...

Could you rephrase it to What is the recommended minimum memory requirement ...?

What are the benefits over what Ola's maintenance script[/url] is already providing?

I haven't been investigating service broker because:

Our team already uses Windows Message Queuing -> What does service broker does better?

Microsoft's tendency to drop features (was really bad in the silverlight...

Been away for a while.

I'm unfamiliar with isci-target (this technology?).

Is it possible to consult your Netapp vendor? Could only find best practices for sql server on Netapp, it doesn't...

Hello,

->What are the current bottlenecks on the new server? (wait_stats)

Can you use the new vhdx format instead of vhd?

You mention the upgrade of the sql server, did the OS of...

Does OPENQUERY work?

What driver did you use? OraOleDB?

Congratulations Jack & Jason

(1) how important, performance-wise, is it to separate out these files?

->it is easier for management in case you decide to reorganize storage. Logfiles have mostly sequential reads, datafiles are...