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
How to create a dml trigger using create trigger statements?
What different steps will a sql server developer take to secure sql server?
What is the difference between update lock and exclusive lock?
mention different types of relationships in the dbms?
What programming language would you use to create embedded functions in ssrs?
Is resultset an interface?
What are the different authentication modes in sql server? How can it be changed?
What is collation sensitivity? Explain different types.
What is the difference between char, varchar and nvarchar?
What does null mean?
What is the guest user account in sql server? What login is it mapped to it? : sql server security
what are the new features introduced in sql server 2000? : Sql server database administration
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
What is the maximum number of index per table?
Why should you use or avoid select * statements?
