practical advice arounding indexing and ETL?

• KoldCoffee

  SSCoach

  Points: 18971

  More actions

  February 5, 2015 at 10:04 am

  #1775773

  without them.

• Nevyn

  SSChampion

  Points: 14210

  More actions

  February 5, 2015 at 10:37 am

  #1775791

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

• MMartin1

  One Orange Chip

  Points: 27799

  More actions

  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"> 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

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