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
Can we join two tables without primary key?
What are character string data types in ms sql server?
what is a transaction and what are acid properties? : Sql server database administration
Do you know what is blocking?
What are the steps you can take to avoid “deadlocks”?
How you can change a cross join into an inner join?
Name 3 ways to get an accurate count of the number of records in a table?
what is checksum in sql server.........???
What are the different types of replication you can set up in sql server?
What is difference between unique and primary key?
How to create and drop temp table in sql server?
In which tcp/ip port does sql server run? Can it be changed?
What are key constraints?
How exceptions can be handled in sql server programming?
What do you need to connect php to sql server?
