December 17, 2009 at 10:09 am
This might seem to be very simple question, but can you all tell me the best practices for fastest transfer of rows from one table to another which are in different databases. I have transaction table in staging database that I did bulk insert from a flat file. Now I am trying to push the rows into the actual table in the production database and need to know the fastest method to move the data. Also could you give me the best practices for drive considerations for the data and log files for the two databases. Inserts are being done everyday almost 24 hours.
December 17, 2009 at 10:37 am
Thank you for the reply. Here are the details.
1. SQL Server 2008 Enterprise Edition 64 Bit SP1
2. Records are inserted first into the Staging table from the flat file using bulk insert. I am fine there.
3. We are talking about 20-25 GB of data every day.
4. Once it is in the staging table it is only doing inserts to the final table. We are also trying to see if we should do bulk insert straight into the actual table and remove the staging part.
5. Yes the table is partitioned.
6. The storage is connected to SAN and right now the log file for both the actual database and the staging database are on the same drive.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply