Thanks, that is from the management studio. Is there a commandline equivalent?

Maybe you can ask the oracle engine to convert it to xml first (instead of clob). Possible example[/url]

Not sure if it is fixed yet but discusses about casting it as xml-type in openquery

Haven't it used in sql server

Add a line with execute as?[/url]

Perhaps better:

DDL-triggers evaluating eventdata on INSERT/UPDATE/DELETE/MERGE/TRUNCATE...

http://technet.microsoft.com/en-us/library/ms173781.aspx

Mostly sqlservercentral, blogs including other technologies, and yearly ms community days

Skip items included...

Welcome Erland,

Agreed the CTP-forums had their time now.

About sql 2012, it is fairly new, runs best (?) on windows 2012 (also new) and above all had its licensing changed (cores...

Have a pleasant stay in Afghanistan Lynn

We install manually after the blank os on the virtual machine has been provided. Usually takes two weeks to a month before it gets planned in. Bigger items a year...

Have no experience with realtime replication. How realtime is it (ns, ms, minutes...). Is it realtime part oneway (oracle+msql) to ms sql server?

Triggers have a disadvantages

Great article, Chaos Monkey went opensource

Honeypot accounts may be easier to implement

Hopefully MS finds something.

Oracle Net services tuning (buffers).

Have you checked that offload/chimney on the nic is off? Can cause troubles.

For sqlplus you might have to check the fetch/arraysizes

SQLPlus tuning...

Congratulations Wayne and Jason with your MCM

Hello Nicolas,

Where does the condition GROUPED.TOTAL_DURATION = AL3.DURATION come from?

You could also try to use a "WITH clause"

WITH mysubquery AS

(SELECT ...)

SELECT EXTRA.*

FROM EXTRA

INNER JOIN mysubquery on extra.X=mysubquery.Y

My attempt to an...

Does the oracle universal installer mentions that the odbc-driver is installed?

What version of the 11g driver did you install 32-bit or 64-bit, instantclient vs full client?

*

Search this forum on SSIS...