Viewing 4 posts - 31 through 34 (of 34 total)
Mohan Kumar-480059 (10/25/2009)
We have some databases which are around 10gb now. Due to performance issues I was instructed to partition the tables. I've gone through...
October 26, 2009 at 3:17 am
In my experience if the lookup dataset is small enough to use full caching then the SSIS lookup component is blindingly fast - everything is done in memory & highly...
September 23, 2009 at 4:51 am
If you are using full caching check how many rows there are in the lookup table/view.
If the table you are using for lookups is huge then consider using partial caching...
September 23, 2009 at 4:42 am
Have you tried updating statistics on the table in question, you may be getting a poor execution plan if your statistics are out of date??
Maybe try UPDATE STATISTICS
September 23, 2009 at 4:36 am
Viewing 4 posts - 31 through 34 (of 34 total)