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
application server is slow what may be the problem
What is Cross Join and in which scenario do we use Cross Join?
What are the types of ssrs?
explain the storage models of olap? : Sql server database administration
What are different types of data sources?
What is raid, and how it can influence database performance?
In what version of sql server were synonyms released?
How to get all stored procedures in sql server?
What is a bit datatype?
How you can find out if an index is useful to the optimizer?
tell me what is blocking and how would you troubleshoot it? : Sql server database administration
When should you use an instead of trigger?
what is the difference between openrowset and openquery?
What are the new features of sql server 2008 r2 reporting service?
Can primary key be null?