Richard Warr (1/23/2013)

---

A NOT EXISTS may be better than a NOT IN

Something like

SELECT CONVERT(VARCHAR(4), R.FCde) AS Flty

FROM Rtns R

WHERE NOT EXISTS ( ...

Richard Warr (1/23/2013)

---

A NOT EXISTS may be better than a NOT IN

Something like

SELECT CONVERT(VARCHAR(4), R.FCde) AS Flty

FROM Rtns R

WHERE NOT EXISTS ( ...

Anyone?

Luis Cazares (1/18/2013)

---

Using your examples:

( 'Ab','BC',CD') are non-Unicode strings (char/varchar)

(N'Ab',N'BC',N'CD') are Unicode strings (nchar/nvarchar)

The datatypes are differents and the clearest example of it is that a char(1) uses 1byte and...

implicit conversion on what?

I don't want to trace to run 24 X7 as i don't know when the issue would occur. I wanted...

In place of email address just type ' yourcellphonenumber@verizon/att.net'

still trying to understand when and where tempdb would use proporational algorithm and rounnd-robin

GilaMonster (11/12/2012)

---

No.....

IO latch contention...

Application is running slow and i do see the calls made by webserver are...

GSquared (11/7/2012)

---

Standard, normal, boring Read Committed usually works just fine for that kind of situation.

If you find that the few in-day updates are causing more blocks than you like, switch...

GSquared (11/7/2012)

---

sqldba_newbie (11/7/2012)

---

GSquared (11/7/2012)

---

It depends on what end result you want.

Read Committed Snapshot Isolation will help prevent blocking, but allows "old data" to be seen by concurrent transactions. Doesn't...

GSquared (11/7/2012)

---

It depends on what end result you want.

Read Committed Snapshot Isolation will help prevent blocking, but allows "old data" to be seen by concurrent transactions. Doesn't have the...

GSquared (11/7/2012)

---

The first one will do what you're looking for. Isolation levels are set for the connection, not for the object.

HOWEVER, I have to warn you that setting isolation...

anyone?