Answer Posted / suraj
like this
select *
from dbo.Address
with (nolock)
-- above query doesn't hold lock while retrieving data.
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Explain how to maintain a fill factor in existing indexes?
What is rtm version in sql server?
What are the types of ssrs?
How can a user-defined datatype be created?
What are tables in sql server?
Why and when do stored procedure recompile?
sql database suspect We have a sql database that is showing as suspect. How can we recover?
What are alternate keys?
Explain the database you used in your final year project?
Do you know sql server 2008 backup compression?
What are two difference between sql azure and azure tables?
What is an expensive query?
How many types of schemas are there?
What is BCNF? How is it better than 2NF & 3NF?
You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?