plantation

What is the source definition for the affected columns?

Do you get any errors?

I second Lynn. I prefer to use NT users and Groups when possible.

I would rather set the fillfactor on a per index basis and not have one setting apply to them all.

Please provide table structure so we can provide some feasible answer.

Yippee skippee.

Let's have more questions on 2012

Wish it were true.

Thanks for the article Jeff.

I have used each of those and prefer ERWin.

Just a reminder that using DISTINCT often times is masking a bigger issue. Perhaps if you provided sample data and sample tables with your sample query, a better solution...

You are welcome.

SQL_Enthusiast-AZ (3/27/2012)

---

Thank you Everyone,

The REPLACE worked; however, after running the query, I found thousands records with all kinds of non-numeric values. That's is a lot of REPLACE(REPLACE(REPLACE...

So, I turned it...

GSquared (3/27/2012)

---

Gianluca Sartori (3/27/2012)

---

GSquared (3/27/2012)

---

L' Eomot Inversé (3/27/2012)

---

Stefan Krzywicki (3/27/2012)

---

GSquared (3/27/2012)

---

[It's a lot of posts, but I've never understood any fascination with "milestone" posts. Number in Hex, Oct, or...

http://it.toolbox.com/blogs/sql-tuning/implementing-ms-dtc-in-windows-2008-cluster-service-with-sql-server-28329

http://www.ryanjadams.com/2011/07/move-cluster-quorum/