Toreador (4/21/2010)

---

...although I was (I think) the first person to comment on the answer to the second part...

sturner (4/20/2010)

---

It could be as simple as:

if not exists(select 1 from maint_req where request_type = 'AROLE')

insert maint_req..........

Dohsan (4/21/2010)

---

This may work better

CONSTRAINT CHK_TextCol CHECK (TextCol NOT LIKE '%[^Aa-Zz]%')

Tom Brown (4/21/2010)

---

This is excellent Paul, Thank-you.

Glenn Dorling (4/20/2010)

---

So for the first part you're assuming explicit behaviour but for the second you're assuming implicit behaviour.

shen-dest (4/21/2010)

---

CXPACKET wait type indicates that there is parallelism issue.

jonwolds (4/21/2010)

---

I'm just wondering how every thread can be waiting on CXPACKET without being a intra query dead lock? One of the theads must be wating on something else?

rafa.aborges (4/20/2010)

---

My question is if the overhead on the tempdb database is on its transaction log only not in the whole database.

srik780 (4/20/2010)

---

thank u very much and In your answer what is 'SO' means what is the use of that?

Oleg Netchaev (4/20/2010)

---

After reading Part I last week I knew that Part II is going to be good, but I did not expect it to be this good!