Or you could use heavy duty material to remove the tree (bulldozer, tractors, chainsaws...). The options keep growing.

Payback for my excellend sql server teacher and others on this forum.

Working with Oracle subforum: Driver mania

I have no experience with SSIS but would leave a minimum of 2 GB for the OS/other applications (max memory<6 GB).

Have a look at

Sql server best practices on technet

MSDN

Specific on...

As an accidental Oracle dba myself (coming from sql server 2000) I've found the Oracle concepts most interesting to grasp what the main differences are.

After that backup/restore (rman, needs...

if it is an index, you could try to drop it and rebuild

Maybe we will wait until Release 2 comes out. By the time it is well established.

Have you checked for double-hop issues?

Technet

Forum post

Had no troubles with ora oledb so far. Selecting 10000 rows works fine. Perhaps a mismatch in "case" with the CaSe sensiTive Oracle?

I still need to test against some linked...

Why don't you use the CASE-statement instead of decode?

sum (CASE WHEN ACTIVITY='X' OR ACTIVITY='Y' ... THEN 1 ELSE 0 END)

Also have a look an analytical functions for Oracle.

What is your current bottleneck? Cpu, I/O ...?

what oracle driver did you install on the sql server ? 9i, 10g, 11g?

No problem, as long a normal without adminrights can run the developed software (in most cases).

Any chance to trace on the oracle side the query mssql generates, to see if mssql actually passes the where clause or tries to pull the whole table.

Have a look at

Your way is much clearer than mine using the full oracleinstall.