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!

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...