Archive for the ‘Performance tip’ Category

Introduction to SQL Server 2012 Parallel Data Warehouse (2013-12-25)

Surprisingly how we over the years have accepted that we need to invest a lot of time and energy to move data from ‘A’ to ‘B’  and to maintain a well performing data warehouse platform where your reports & queries respond within a reasonable amount of time (and I’m not referring to just SQL Server […]

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