Answer Posted / michael
Advantage:
applying nolock in select statement will increase
concurreny and performance in fetching.
Disadvantage:
it does'nt consider the transaction scenario, even if the
transaction is under process not yet commited or rollback
it will fetch the current record
eg
begin tran
insert into tablename
values('1','asdf')
select * from tablename with (nolock)
-- it will display the table with inserted record.
but the transaction is not completed, it can be rollback
so it became dirty read.
Is This Answer Correct ? | 28 Yes | 2 No |
Post New Answer View All Answers
How to end a stored procedure properly in ms sql server?
What is the difference between nvl and nvl2?
Can you insert NULL in unique column?
How to connect a database with sql express.?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
How to use linked server?
How to round a numeric value to a specific precision?
Tell me what are the advantages of using stored procedures?
What is a synonym for manipulation?
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
What happens if the update subquery returns multiple rows in ms sql server?
How to create a user to access a database in ms sql server using "create user" statements?
What do you mean by collation recursive stored procedure?
Do you know concepts and capabilities of sql server?
What are click through reports?