Nice selection of questions. Got busted on 3,10 & 12

We had a strange cause oracle transactions failing after sometime.

It was fixed with a reboot of the server after an installation of the 11.2 client (for the post reboot...

if the oracle is 11.2 or later you can use recursive WITH-sql instead of connect by

Did the oraclemts service stop running? Do you have the latest oracle client?

Depends on more than just the size. Was the size given in GB ram, GB diskspace. What is the cpu usage and I/O consumption of each?

Which version of Hyper-V 2008...

Also verify that the user have read/write permissions. If they don't have write permissions, the lck file can't be created->exclusive mode

Good question.

The web showed some motherboard that support 32 GB ram and there are 8 gb ram modules available; may 2012 article[/url]. Processor of preference I7.

Or perhaps a secondhand...

a power supply swap is usually a good place to start

nvarchar(255) shouldn't pose a problem. You might want to compensate for slight multibyte storage differences as the size is expressed in bytes.

SQLServer 1-2 bytes(?) vs oracle 1-4 bytes (depending on...

Do you have a recent version of sql developer? [/url]. Have to research it myself

You cannot update emp again from an after trigger (could cause looping). Try a before insert trigger.

Ps why are you updating the whole table (status=1) for each row?

db servername would be the tns-alias, which is described further in tnsnames.ora.

Like mydb. In tnsnames.ora Mydb= (connection info.... tcp....port....) (see the web for the actual connectionstrings)

Other oracle tools:

tracing, perhaps on module sqlserver.exe, or enable from your openquerysession

General oracle performance tuning

Big data is quite diverse nowadays, somewhat like the cloud.

More like specific problems that might benefit from a non-standard RDBMS approach. Like social media/search robots having scaleout methods where one...

Haven't time to setup a mssql to oracle replication, however some possible helpfull links.

SQL Server Replication

Locks in oracle

Perhaps Statspack if installed on the oracle db (small interval)

Dreaded question: anything changed...