Answer Posted / guest
Do not issue shared locks and do not honor exclusive locks.
When this option is in effect, it is possible to read an
uncommitted transaction or a set of pages that are rolled
back in the middle of a read. Dirty reads are possible. Only
applies to the SELECT statement.
| Is This Answer Correct ? | 16 Yes | 3 No |
Post New Answer View All Answers
What is normalization? Explain its different types?
What are key constraints?
What is inner join in sql server joins?
How to Update from select query in sql server?
What is the difference between having clause and where clause in sql server?
Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?
What is meant by indexing?
How to run queries with sql server management studio express?
How to copy the tables, schema and views from one sql server to another?
What are the different types of join?
Are connections to sql server encrypted?
What are different types of data sources?
What is sparse columns of sql server 2008?
What is an index in sql?
What are the advantages of log shipping?
