April 2007 - Posts

• Mantaining order in SSIS flow, problems with Merge

  In a previous post I spoke about the advantages of having sorted flows in SSIS to greatly speed up data insertion using fastload. The need to have a sorted flow brings some severe problems to the SSIS programmer that he need to be aware of and that IMHO Read More... Posted Tuesday, April 10, 2007 9:48 AM by AlbertoFerrari | 2 Comments Filed under: SQL, SSIS

• Making Fast Load really fast on clustered indexed tables with SSIS

  I have been so used to use int identity fields as primary key for any table and to believe it’s the fastest way to define a clustered primary key that I never thought this can cause serious performance problems to SSIS. Until I tested it and discovered Read More... Posted Sunday, April 08, 2007 9:48 AM by AlbertoFerrari | 20 Comments Filed under: SQL Server, SSIS