SanDroid (1/4/2013)

---

SQLRNNR (1/3/2013)

---

dineshbabus (1/3/2013)

---

I think few days back same conversation happened... Unique constraint is different from unique index. While creating unique index we can create with filter and that will...

opc.three (1/4/2013)

---

I was typing while you guys had two more responses, sorry if my last post seemed redundant.

From the resource-list it looks like you might have things accessing resources in...

What is the average run time for your ERP process?

Each of those plans are associated to each process that is captured. It looks as though the sp_executesql is executing the parameterized query. You have the same query...

There is an option that does not require you to to log on and off and back and forth.

Create an SSMS shortcut that relies on the Runas and specify your...

We have done it as a joint effort.

This is not just a database cluster, it is also a windows cluster. There are two clusters installed - the os is...

I agree it could be a little of both. Many shops use two accounts in AD -...

I see that you have captured three processes in this deadlock graph. All three of these are running the same code. Have you checked what the code is...

I will be scheduling additional testing. I also have a few more checks that I will be implementing.

crookj (1/4/2013)

---

SQLRNNR (1/3/2013)

---

Daniel Bowlin (1/3/2013)

---

SQLRNNR (1/3/2013)

---

opc.three (1/3/2013)

---

SQLRNNR (1/3/2013)

---

JAZZ Master (1/3/2013)

---

SGT_squeequal (1/2/2013)

---

crookj (1/2/2013)

---

Daniel Bowlin (1/2/2013)

---

In the immortal words of Uniblab

"Back to work (click), back to work (click). Everybody ( click) work,...

Vegard Hagen (1/4/2013)

---

No, a shrink with no_truncate will "shrink" the data file without actually shrinking it.

I'm "impressed" that a vendor like Symantec would actually make such recommendations. I mean...

Glad it is working for you.

One thing we...

Dineshbabu (1/4/2013)

---

SQLRNNR (1/4/2013)

---

A single column Unique constraint can have only one Null value (unless you use the filtered index version of a unique index) which some debate is not a...

Like Dwain said,

change this line

and n.Note like '%[0-9A-Za-z.][@] [0-9A-Za-z.]%'

to this

and n.Note like '%[0-9A-Za-z.][@][0-9A-Za-z.]%'