Interested to Buy Any Domain ? << Click Here >> for more details...
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
Do you know what are the restrictions that views have to follow?
What is the difference between an index and a unique index?
What are the different authentication modes in sql server?
What is the difference between inner join and equi join?
Can primary key be null?
Explain what is the use of custom fields in report?
What is reference section?
What are the differences between union, intersect, and minus operators?
How to check status of stored procedure in sql server?
what are acid properties? : Sql server database administration
How will you find out if there are expensive SQL statements running or not?
How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?
What will be the maximum number of index per table?
Explain transaction server implicit?
Why functions are used in sql server?
