I would test what size it should be set at.  Batch size controls commit actions.  If you're bcp'ing 1,000,000 wide rows and your constantly waiting for your log file to...

You can set your batch size. This will sometimes speed things up.

Tom

How many indexes are on the table.  Try dropping the indexes during the bulk load and rebuilding them afterwards.

Tom

I ran into a similar problem the other day.  There was a varchar field used to store an integer.  The program was getting the next int value by selecting the...

Mike,

Try running. sp_updatestats.   I also will run sp_createstats on some tables to give the optimizer more options.

Tom

Mike,

When was the last time you rebuilt the indexes on the table.  Run dbcc showcontig on the tables involved on each system and post that.  It will show the index...

Mike,

How many processors are on each server??Try this hint on the slower, beefier machine.  Run it with the stats set.

At the end of the select add:  option maxdop 1

Thanks

Tom

What about the processor? 

Run this on both machines and post the output from the query analyzer messages tab.

set statistics io on

go

set statistics time on

go

--your code here

Try that, I'll take a...

Is the data the exact same on both servers.  Have statistics been updated on both servers.  No raid will run faster than raid5.  What about processor speed. 

Tom

If I remember right, you have to Issue the

restore database test with recovery

after you restore the log.

Tom

Here's a script you can run in each database that will list out the objects each user owns.

select b.name,a.name from sysobjects a join sysusers b

on a.uid = b.uid

where b.name =...

Has this database been in full recovery before?  Try this if you can.  Detach the database and re-attach a single file db.  A new log file will be created.  See...

I would not make that assumption.  You're assuming that they are good programmers which isn't always the case.  Some other things I'd look at:  Are statistics being updated? Are indexes being...

Are these databases all off of the same production server.  If they are I would copy the users and sids from the production server and create them on the QA...

Are things indexed correctly?  I'm don't know your application but you could also use the nolock hint for dirty reads.

Tom