When You Execute Sql Statements Within Integration Services The #493
When you execute SQL statements within Integration Services, the following optimization can be made?
This multiple choice question (MCQ) is related to the book/course
gs gs116 Microsoft SQL Server.
It can also be found in
gs gs116 Data Connectivity - SQL Server Integration Services - Quiz No.2.
When you execute SQL statements within Integration Services, the following optimization can be made?
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
In SQL Server 2008 Integration Services, there is a new feature of the shared lookup cache
If you cannot use commit size 1, use the highest possible value of commit size to reduce the overhead of multiple-batch writing
All of the mentioned
Similar question(s) are as followings:
Online Quizzes of gs116 Microsoft SQL Server
Developing with SQL Server - Error Handling - Quiz No.1
gs gs116 Microsoft SQL Server
Online Quizzes
Laying the Foundation - Aggregation of Data - Quiz No.1
gs gs116 Microsoft SQL Server
Online Quizzes
Laying the Foundation - Joins in SQL Server - Quiz No.1
gs gs116 Microsoft SQL Server
Online Quizzes
Laying the Foundation - Views in SQL Server - Quiz No.1
gs gs116 Microsoft SQL Server
Online Quizzes
