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 |
|
SuperGhost
Starting Member
12 Posts |
 Posted - 2008-03-31 : 21:02:37
|
| What will happen if I'm running a query with the NOLOCK hint but the SQL Server has run out of resources?Thanks! |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-31 : 23:27:17
|
| Not sure what you mean, nolock saves resource since each lock needs memory. |
 |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2008-04-01 : 09:10:33
|
there are (at least) two problems with reading NOLOCK:1. the data you get back may be uncommitted, so it's not safe to use in applications that care about data integrity. 2. it can cause your query to simply fail.
elsasoft.org |
|
|
|
|
|
|
NOLOCK and no resources?