Synchronous and asynchronous components, memory buffers, data type choices, Oh My!
Tuning the data flow is all about choices.
In this session we'll walk through some of the choices that can give you the biggest performance boosts in your SSIS data flow. Together we'll work through the differences between synchronous and asynchronous components. We'll highlight components that should be avoided and explore alternates that can help us create the fastest data flow possible.
We just ran into Tim at Microsoft the other day and he was NOT sporting his yellow laptop. His company laptop was a very un-Tim gray; though he had made amends with his screaming yellow mouse. In support of Tim, bring your favorite yellow food. We'll make sure we get our US RDA of yellow #5!We will be providing food as usual, just of a slightly different hue.