Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
You are optimizing several Transact-SQL statements. You have determined that a particular statement will perform more efficiently if a lock is applied at the row level rather than at the page or table level.
Which of the following table hints will you use in your Transact-SQL statements when performing optimization?
on 11/30/2012 | Category:
Sql Server Interview questions
| Views: 1781 |
Select from following answers:
When you use the ROWLOCK table query hint, row locks will be used when page or table locks are likely to be used.
When you use the READPAST table query hint, rows in the table locked by other transactions are skipped rather than blocking the transaction.
Show Correct Answer
Microsoft press book | |
< Previous :
Which of the following queries that use string fun ...
Next > :
You want to use the appropriate function to conver ...
Comments or Responses
Login to post response
More Interview Questions by Rajkatie
You want to use the appropriate function to convert a binary value to ...
The Employee table of the AdventureWorks2012 database includes informa ...
You want to remove the Odometer column of the Hovercraft table. This t ...
Recently, systems administrators scaled a web application you designed ...
You recently deployed an ASP.NET web application. Although the applica ...
You are designing a web application that will be deployed across ten s ...
You are creating a view for an MVC application. You need to create a n ...
Latest Interview Questions
You have a Transaction table which is very important table because it ...
Write a C# sharp Program to check wheather the given string is Palindr ...
Which namespace will you use to get the value of connection string def ...
Write a C# program that prints the Prime numbers between 1 and 100 and ...
There is a PDF file which contains "GuideLines" in particul ...
Write a program in C# using Linq that prints count of leap years in 20 ...
Explain how do you differentiate between design pattern and framework ...
What is a design Pattern?