sorry, heavy ETL and warehousing.
We want to understand how the sql 2005 64 bit perf can be maximixed or configured correctly.
We have 2 new AMD Opteron 8 core 2.2 Ghz with 12GB ram servers for heaving
ETL and warehousing.
We are running sql 2000 on all the other...
FWIW, I ran the DTS package "on the destination sql server" with
Fetch Buffer = 1000 to get 1000 Oracle rows at once
Ok, good points:
1. I should lock the target table using WITH TABLOCK.
2. Separate Hard Drive for TempDB:
Yes, you are absolutely right !
I ran the DTS package on the destination Sql Server and the time ran 50% faster.
Estimated 20 hrs using...
Ok, thanks for all the replies.
1. DTS option
I finally decided to use DTS with fetch buffer = 1000 and Batch = 5000 (commit rows).
Thanks, I thought so.
I have 25Million rows to copy from Oracle to Sql Server every month.
Do I need to somehow configure tempDB to...
If I understand correctly, initiating a DTS request from
Ent Mgr on my PC is not the same as initiating the DTS request when
logged in to...
When DTS is transferring data, does it use tempdb ?
If so, can we avoid it so that tempDB won't fill up when loading
Millions of rows ?...
I want to copy a subset of Oracle data to Sql Server 2000 staging table.
There are about 22Million Rows in this table.
I have a sql query to...
Separate names with a comma.