Which Of The Following Design Strategy Can Reduce The #831
Which of the following design strategy can reduce the occurrence of blocking locks?
This multiple choice question (MCQ) is related to the book/course
gs gs116 Microsoft SQL Server.
It can also be found in
gs gs116 Performance Tuning and Optimization - SQL Server Blocking - Quiz No.1.
Which of the following design strategy can reduce the occurrence of blocking locks?
Use non-clustered indexes on high-usage tables
Use clustered indexes on high-usage tables
Use clustered indexes on less-usage tables
Make sure that CREATE and DROP statements use an existing index
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
