I have been reading the famous
Integration Services: Performance Tuning Techniques document and I want to use the guidance in the Buffer Sizing section.
In order to optimize my settings for DefaultMaxBufferRows and DefaultMaxBufferSize, I need to calculate the Estimated Row Size for my Data Source.
However, when I look to the
Integration Services Data Types document I find that several of the data types do not explicitly list their size in bytes.
(DT_BOOL also isn't listed but the assumption must be it's one bit)
Does anyone know how big (in bytes) these data types are? The Estimated Row Size can't be found without them.
View Complete Post