The vast majority of the time, you will use SSIS Lookup component in Full Cache mode. This mode is the fastest because it queries the database only once (before the data flow starts) and apply hashing in order to do high-performance comparisons. Sometimes however you will have to use Non Cached lookups. For example if […]
Archive for May, 2011
May 19, 2011 by Francois · Leave a Comment
Filed under: Performance, SSIS
Social Tagging: covering index • indexes • io statistics • Lookup • Non Cached Lookup • Partial Lookup • SSIS
Filed under: Performance, SSIS
Social Tagging: covering index • indexes • io statistics • Lookup • Non Cached Lookup • Partial Lookup • SSIS
May 6, 2011 by Francois · Leave a Comment
Filed under: TSQL
Social Tagging: @@IDENTITY • bug • INSERT • OUTPUT • SCOPE_IDENTITY() • sql • sql server • TSQL
Filed under: TSQL
Social Tagging: @@IDENTITY • bug • INSERT • OUTPUT • SCOPE_IDENTITY() • sql • sql server • TSQL
It is a common business case to have to reuse the auto-generated SQL Server’s IDENTITY value. One way to deal with the problem is to use the system function @@IDENTITY. For example:
RSS