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
What is table constraint?
What are the properties of the relational tables?
Why we use the openxml clause?
What is Federation Root Database?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
What are commonly used odbc functions in php?
How you can get a list of all the table constraints in a database? : Sql server administration
What is an indexing technique?
What are types of storage modes? : sql server analysis services, ssas
What is reference section?
whats new about truncate in sql server 2008?
what are defaults? : Sql server database administration
Write a SQL query in order to merge two different columns into single column?
What do you understand by recursive stored procedures?
How except clause is differs from not in clause?
