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

Agreed, I grasped that per VM there are 4 core licenses necessary. So you only need 4 no matter the underlying hardware cluster (if you only use 4 virtual cpu's...

There is a command to lock an entire table LOCK TABLE employees IN EXCLUSIVE MODE NOWAIT; , but haven't tried this from MSSQL. Perhaps through openquery.

Not sure why you...

Congrats with the rescue Jason

Getting ready for windows 7 & windows server 2012.

Relearning MSSQL and improving the current monitoring for facts & figures.

make sure you make it a date-datatype instead of a string using cast or convert

Comparing dates with strings is usually a recipe for disaster

Nice that the DTA advisor mentioned a missing index, even learned a new keyword "includes" (any benificial scenario's for include?). A rewritten index made it even better.

I was looking for a random news fact dated 19th of november 2000. Milk Inc is mentioned at the bottom.

DBCC Timewarp: Active Directory returns to 19 november 2000. New singer Linda Merts for the popular belgium pop/dance group. Waar zijn die handjes?:-D