Post reply

practical advice arounding indexing and ETL?

  • February 5, 2015 at 10:04 am

    #1775773

    without them.

  • February 5, 2015 at 10:37 am

    #1775791

    How long does the differential take when the indexes are on, say, the largest table?

  • March 4, 2015 at 11:05 am

    #1781710

    Just to cover, there are no triggers firing on the destination table correct?

    Also from this page https://msdn.microsoft.com/en-us/library/ms141237(v=sql.105).aspx

    I can see where it reads "Performance can be improved if you use the ORDER option to sort the input data according to the clustered index on the table. " Perhaps that can offer some benefits with using the Fast Load option with a SSIS data flow destination

    ----------------------------------------------------

Viewing 3 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply