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

Help needed with cross-vendor replication mssql->oracle

Have you also checked the oracle-side? (tracing,locks etc)

Happy New Year

Can't tell much without actually seeing it. I had success using orafaq[/url], just be sure you read the forum guide. Do you have a testcase (create table, insert data, select...