Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pushp82
Yak Posting Veteran
83 Posts |
 Posted - 2012-02-18 : 02:26:35
|
| Hi,I may be stupid to ask this question here but can someone tell me is there any option available to find out dirty reads or how can I determine it.Please help and thanks in advance.....Pushp |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-02-18 : 05:03:35
|
| Dirty reads are reads of changed data that later gets rolled back, or partially completed changes. You can only get them if you're running in the read-uncommitted isolation level, so avoid that and you won't get them--Gail ShawSQL Server MVP |
 |
|
|
pushp82
Yak Posting Veteran
83 Posts |
Posted - 2012-02-18 : 06:35:01
|
thanks GilaMonster....actually what I want to know is in case of mobile application some time server response to the request but some time not.. So I want to check if any kind of dead lock occurs there in case of heavy hitsquote:
Originally posted by GilaMonster
Dirty reads are reads of changed data that later gets rolled back, or partially completed changes. You can only get them if you're running in the read-uncommitted isolation level, so avoid that and you won't get them--Gail ShawSQL Server MVP
|
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-02-18 : 07:12:24
|
| Huh?Deadlocks have nothing to do with dirty reads. What exactly is your concern/problem here?--Gail ShawSQL Server MVP |
|
|
|
|
|
|
Dirty Reads