Home Forums SQL Server 2012 SQL 2012 - General Data loading best practices for 5-10 millions of rows. RE: Data loading best practices for 5-10 millions of rows.

  • October 25, 2013 at 10:13 am

    #1661677

    Minaz (10/24/2013)

    Hi Expert,

    As this a huge environment wanted to impement best practice for loading 5 - 10 millions of rows, please advice.

    How do I take care of costraint and indexes?

    Is drop / recreate indexes is good or dissable and enable indexes?

    in both scenario if my cluster index is dropped or dissable, no one will be able to access the table hence data loading will break.

    I was reading one article which suggested dissbling cluster index will dissable all the associated non cluster indexes and then enable the cluster index , do the data loading and enable all the non cluster index and rebuild all.

    I need your input.

    This would be, IMHO, a very good candidate for using a staging table (you should always use a staging table for imported data for many reasons) and partitioning.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)