Home Forums SQL Server 2012 SQL Server 2012 - T-SQL best way to transfer data RE: best way to transfer data

  • March 5, 2013 at 10:47 am

    #1593567

    monilps (3/5/2013)

    Hi,

    I have two tables (one is main table and another one is staging table)

    Ex: tableA (contains 1.2 billion rows, trigger for arrival timestamp for insert and update and non clustered index).

    tableA_staging (92 million rows, no trigger and no index)

    I am currently trying it and takes around 10 hour and still data is not transferred.

    Can you please suggest some best way to transfer data from staging table to main table.

    Thanks in advance.

    Which exact direction you are transferring your data? Staging to main?

    Please post complete DDL for your tables and trigger.

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]