tag:blogger.com,1999:blog-8600927897234142120.post4870350000358764252..comments2023-12-23T03:43:29.570-08:00Comments on BI Polar: Indexes and SSIS Data Flow PerformanceMatthew Rochehttp://www.blogger.com/profile/17230399970488763978noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-8600927897234142120.post-12971899179340468922009-03-23T12:41:00.000-07:002009-03-23T12:41:00.000-07:00Lesson Learned!We usually Bulkload into a Staging ...Lesson Learned!<BR/>We usually Bulkload into a Staging table. Drop the indexes, load the data and transformations and then rebuild the indexes.<BR/><BR/>Could you imagine a table with 12 Billion Rows? Currently takes 2 hours to load 115 million rows into 2 separate servers.Carolus Holmanhttps://www.blogger.com/profile/03780785540721269994noreply@blogger.com