Time MDX Cheat Sheets-SSAS. Alberto Ferrari : 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 that int identity primary keys are among the slowest way to insert huge amount of data with SSIS. In the post I’ll describe the technique that – from my tests – is the fastest way to insert data into tables with clustered index using SSIS. We Loaded 1TB in 30 Minutes with SSIS, and So Can You. SQL Server Technical Article Writers: Len Wyatt, Tim Shea, David Powell Published: March 2009 Applies to: SQL Server 2008 Summary: In February 2008, Microsoft announced a record-breaking data load using Microsoft® SQL Server® Integration Services (SSIS): 1 TB of data in less than 30 minutes.
