Dev (11/16/2011)

---

I had one of those. I sat down with the architect and explained to him what NoLock actually did and what effects it could have. The standards...

Michael Valentine Jones (11/16/2011)

---

Using SNAPSHOT isolation or READ_COMMITTED_SNAPSHOT completely avoids any need to use NOLOCK and avoids its bad side effects.

Since this has been available since the release of SQL...

Stefan Krzywicki (11/16/2011)

---

L' Eomot Inversé (11/16/2011)

---

Ninja's_RGR'us (11/16/2011)

---

Brandie Tarvin (11/16/2011)

---

Dangnabbit! You caught me. Yes, I do work for the Celestial Intervention Agency...

Darned humans. You're...

DDS requires enterprise version.

There's a way to fake that in standard but it's a pita.

Steve Malley (11/16/2011)

---

My personal preference is to use the statement:

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;

at the beginning of predominantly read-only stored procs. That way, you don't need the...

That's why I only agree to come in solo or team lead :-D.

Tell us something...

Maybe that could become a an new db or server option.

SET BAN_READUNCOMMITTED = ON.

And then it just ignores it with a printed warning or something. :hehe:

CIA is intechangable with many agencies! 😉

Brandie Tarvin (11/16/2011)

---

Do you have the authority and control to completely rewrite this process?

If so, I urge you to to move the updates, inserts and deletes to a completely different...

Brandie Tarvin (11/16/2011)

---

Dev (11/16/2011)

---

ashuthinks (11/16/2011)

---

@gila yes sir...

i knew that if i don't use NOLOCK i will definitely get a deadlock so for successful

execution i need to use...

DUMP or DROP...

krishikrish (11/16/2011)

---

Ninja's_RGR'us (11/16/2011)

---

krishikrish (11/16/2011)

---

@steve-2 Jones

Yes, i can and tables do get created when I run the queries given in the install logs manually. Must be a connection issue only. But...

krishikrish (11/16/2011)

---

@steve-2 Jones

Yes, i can and tables do get created when I run the queries given in the install logs manually. Must be a connection issue only. But how and...

Can you change the default parameter to take there values from a query?

Then have that query change the output based on the time of day.

Worse comes to worse, maybe you...