Buy Questpond's video subscriptions on
huge discount
.
Online: 710
Home
Articles
Interviews
Forums
For Beginners
Popular Questions
ITIL Career Advice
PMP Career Advice
Career Advices
Codes
Videos
ASP.NET
ASP.NET MVC
Android Intel XDK
Sql Server
AngularJS
Bootstrap
Backbone.JS
MongoDB
LESS (CSS)
jQuery
WPF
WWF
SSIS
LightSwitch
Tutorials
News
ASP.NET MVC
|
Be Interview Ready
|
Top Performers
|
DNF MVP
|
Top Posts
|
Winners
|
Subscribe
|
Catalogs
Welcome Guest !
Register
Login
Home
>
Interviews
>
Sql Server
>
Loading ...
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 page level rather than at the table or row level.
Which of the following table hints will you use in your Transact-SQL statements when performing optimization ?
Posted by
Rajkatie
on 6/30/2013 | Category:
Sql Server Interview questions
| Views: 16278 |
Points: 40
Post
|
Interview FAQs
|
Exclusive Questions
|
Interview Home
Select from following answers:
ROWLOCK
PAGLOCK
TABLOCK
All Above
When you use the PAGLOCK table query hint, a lock is placed at the page level rather than at the row or table level.
Show Correct Answer
Asked In:
measureup.com |
Alert Moderator
Bookmark It
< Previous :
Which of the following Transact-SQL statements do ...
Next > :
You are optimizing several T-SQL statements. You h ...
Comments or Responses
Login to post response
More Interview Questions by Rajkatie
You are optimizing several T-SQL statements. You have determined that ...
You are optimizing several Transact-SQL statements. You have determine ...
You are optimizing several T-SQL statements. You have determined that ...
You are optimizing several complex queries. You have determined that y ...
You are optimizing several complex queries. You have determined that y ...
You are optimizing several complex queries. You have determined that y ...
You have noticed that a particular block of Transact-SQL code triggers ...
An error occurs when you execute a block of Transact-SQL code, causing ...
Latest Interview Questions
In.Net which is the parent class to create all windows service?
What is infonomics?
how to change the database owner?
What is the maximum size of columns in a particular table?
How to convert server name to host name?
How can you detect the servername ?
How can you detect the host name and Ip address?
How can you detect the version properties?
More ...