Sail E0 Webinar
Question
When you execute SQL statements within Integration Services, the following optimization can be made ?
Options:
A .  If Integration Services and SQL Server run on the different server, use the SQL Server destination instead of the OLE DB destination to improve performance
B .  In SQL Server 2008 Integration Services, there is a new feature of the shared lookup cache
C .  If you cannot use commit size 1, use the highest possible value of commit size to reduce the overhead of multiple-batch writing
D .  All of the mentioned
Answer: Option B


When using parallel pipelines (see points #8 and #10 below), it provides a high-speed, shared cache.


Was this answer helpful ?
Next Question

Submit Solution

Your email address will not be published. Required fields are marked *

More Questions on This Topic :


Latest Videos
Chapter 1 - GLOBAL STEEL SCENARIO & INDIAN STEEL INDUSTRY Part 1 : (13-04-2024) INDUSTRY AND COMPANY AWARENESS (ICA)
Direction Sense Test Part 1 Reasoning (Hindi)
Chapter 1 - RMHP / OHP / OB & BP Part 1 : (14-02-2024) GPOE
Cube & Cuboid Part 1 Reasoning (Hindi)
Data Interpretation (DI) Basic Concept Reasoning (Hindi)
Counting Figures Part 1 Counting Of Straight Lines Reasoning (Hindi)
Sail E0 free webinar Webinars
Real Numbers Part 7 Class 10 Maths
Real Numbers Part 1 Class 10 Maths
Polynomials Part 1 Class 10 Maths

Latest Test Papers

DSP Combined 1 Free Revision Test SAIL JO E-0
GPOE / GPA Combined 1 Free Revision Test SAIL JO E-0
BSP Plant Specific Review Test SAIL JO E-0
BSL Combined 1 Free Revision Test SAIL JO E-0
GFM Combined 1 Free Revision Test SAIL JO E-0