Question
a.
Heap inserts are typically slower than using a clustered index
b.
Use partitions and partition SWITCH command; i.e., load a work table that contains a single partition and SWITCH it into the main table after you build the indexes and put the constraints on
c.
Use the NOLOCK or TABLOCK hints to remove locking overhead
d.
Use a commit size of <5000 to avoid lock escalation when inserting; note that in SQL Server 2008 you can now enable/disable lock escalation at the object level, but use this wisely
Posted under SQL Server
Engage with the Community - Add Your Comment
Confused About the Answer? Ask for Details Here.
Know the Explanation? Add it Here.
Q. Point out the wrong statement.
Similar Questions
Discover Related MCQs
Q. Which of the following error message indicates that the package cannot run in SSIS?
View solution
Q. Which of the following is the event logged by the Integration Services?
View solution
Q. Purpose of SQLISPackage_12546 event in SQLIS package is to _____________
View solution
Q. A basic package in SSIS includes the following elements?
View solution
Q. Which of the following evaluation operation is provided in SSIS?
View solution
Q. The __________ is an Access add-in program that provides data analysis tools for financial analysis.
View solution
Q. Point out the correct statement.
View solution
Q. When you _______ an Access table from a SQL Server, SSMA restores the original Access table and its data.
View solution
Q. __________ is a tool for migrating databases from Microsoft Access versions 97 through 2010 to Microsoft SQL Server 2005.
View solution
Q. Point out the wrong statement.
View solution
Q. Which is the most serious issue after migration of access database to SQL Server?
View solution
Q. Which of the following option is used to find database objects by using filter criteria?
View solution
Q. Which of the following change took place in JULY 2014 release of SSMA?
View solution
Q. _________ shows information about Access databases that have been added to the project.
View solution
Q. Which of the following network protocol should be selected to enable IP address?
View solution
Suggested Topics
Are you eager to expand your knowledge beyond SQL Server? We've curated a selection of related categories that you might find intriguing.
Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!
