Archive for August, 2010

SQL2008 R2 DCE on a 96 core Unisys ES7000 server with DSI Solid State storage: Bulk Inserting 1 Terabyte within 10 minutes (2010-8-23)

Hopefully you have seen the high-speed data loading demo live over the last 1.5 years at some SQL Server conference? I remember demoing it the first time –live- with Thomas Kejser at the European SQLPass 2009 conference during the opening keynote to show the 64+ Core support in SQL2008 R2. But for those of you [...]

How to Speed Up SSIS Derived Columns Transformations (2010-8-20)

Sedat Yogurtcuoglu noticed that’s it’s possible to increase the throughput of a pipeline by splitting Synchronous Transformations into Multiple Tasks in the same synchronous execution tree; we ran a series of tests with various number of Derived Column tasks and found out that it’s possible to more than double the throughput. If you want to [...]

Better Tag Cloud