July 2007 - Posts

• Table Difference 1.2

  TableDifference has been updated to version 1.2. For those who want to read the main description of the component can be found here but take a look at the full story, this component and the documentaton has been updated several times. You will find complete Read More... Posted Monday, July 23, 2007 11:16 AM by AlbertoFerrari | 0 Comments Filed under: Components, SSIS, TableDifference

• Generate huge test tables using CTE

  Sometimes I need to have a huge table to make performance tests and I want to create the table easily. I found a simple way of producing these test data using CTE in a creative way and decided to post it so I can have it at hand when needed and maybe Read More... Posted Monday, July 02, 2007 10:18 AM by AlbertoFerrari | 1 Comments Filed under: CTE, SQL Server

• Bulk Insert of sorted data

  In a previous post I showed how to make bulk insert faster using SSIS. During Sql Server Conference 2007 I had the great opportunity to double check it with Stefano Stefani that analyzed the problem in greater detail and finally came up with both an explanation Read More... Posted Monday, July 02, 2007 9:48 AM by AlbertoFerrari | 2 Comments Filed under: Bulk Insert, SQL Server