You can expect:
This is a medium intensity post (you should not get a migraine, but I make no promises).
I Expect (that you have the following experience):
T-SQL Stored Proc experience
Windowed Function experience
Basic Join understanding
Row Number Generation
There are a number of ways to generate row numbers in T-SQL. One way is to create a temp table with an identity column and do inserts into that table. Typically you do it in a while loop with a counter. I've used this method in the past and it...
You can expect:
This is a low intensity post (you should be able to do this in your sleep).
I Expect (that you have the following experience):
Simple SSIS Dataflow work
That you have read and understood/implemented parts 1 and 2
Performance Tuning for SSIS Packages.
Preparation
This is the 3rd and final part to this series. In this part, I will cover techniques and settings in your SSIS packages to tune them so that they perform at appropriate speeds. To really test speed, I need lots of data to test...