Performance of SQL 2005 Versus DB2

Discussion in 'microsoft.public.sqlserver.datamining' started by MS Techie, Nov 3, 2009.

  1. MS Techie

    MS Techie Guest

    I am going to do a lot of bulk inserts (like BCP). Currently I have to decide
    between SQL Server 2005 and DB2 Server. Assuming that there are 2 servers
    with the exact same configuration (same CPU type,same RAM and same Hard disk
    etc.. ).

    If I am doing a Bulk Insert of 10 million records into a table in SQL 2005
    and into a table in DB2 (the table structure is the same in both the
    databases ) , I would like to know where is the bulk insert (or BCP) going to
    take place faster. Is DB2 faster or SQL server 2005 faster.

    Thanks in Advance.
     
    MS Techie, Nov 3, 2009
    #1
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.