Buy Questpond's video subscriptions on
huge discount
.
Online: 2558
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 T-SQL statements. You have determined that a particular statement will perform more efficiently if rows in a table locked by another transaction are skipped rather than waiting for the locks to be released.
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: 16633 |
Points: 40
Post
|
Interview FAQs
|
Exclusive Questions
|
Interview Home
Select from following answers:
READPAST
TABLOCK
PAGLOCK
All Above
TABLOCK table query hint, a lock is applied at the table level rather than at the row or page level.
Show Correct Answer
Source:
measureup.com | |
Alert Moderator
Bookmark It
< Previous :
You are optimizing several Transact-SQL statements ...
Next > :
You are optimizing several complex queries. You ha ...
Comments or Responses
Login to post response
More Interview Questions by Rajkatie
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 ...
You are working with some T-SQL code that causes an error. You want to ...
An error occurs when you execute a block of T-SQL code, causing a tran ...
An error occurs when you execute a T-SQL code. You configure the appro ...
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 ...