I love the fact that a discussion about Facebook has morphed into an argument about legalizing heroin. Somehow, it feels completely sequitur.

Lynn Pettis (4/24/2012)

---

GSquared (4/24/2012)

---

jfogel (4/24/2012)

---

TravisDBA (4/24/2012)

---

You just exactly made my point, you are admitting basically that you are already using (or would use) some type of illegal drug, just not...

jfogel (4/24/2012)

---

TravisDBA (4/24/2012)

---

You just exactly made my point, you are admitting basically that you are already using (or would use) some type of illegal drug, just not blow at this...

Lynn Pettis (4/24/2012)

---

TravisDBA (4/24/2012)

---

You just exactly made my point, you are admitting basically that you are already using some type of illegal drug, just not blow at this time(which BTW...

The query plan suggests an index that it thinks would help. You're getting a lot of scans, and it's possible you need them for this, but have you tried...

I see two things that are almost certainly the performance killers.

The first is this:

LEFT OUTER JOIN MOC_DT.dbo.TCN_Xref tcn

...

Okay, for clarification, is all this is doing is concatenating text together into a single text string, and then putting that in another table?

If so, you definitely don't need a...

Can you post any of the queries?

john barnett (4/24/2012)

---

Steve - you don't buy the software. What you buy is a license to use the software in accordance with the terms and conditions in the accompanying license...

Using varchar to hold date and time data is fine, so long as nobody will ever require that it be used for anything other than a human eye looking at...

I would feel sorry for the passersby.

If they watch me in the...

djackson 22568 (4/23/2012)

---

jay-h (4/23/2012)

---

terrance.steadman (4/23/2012)

---

..My apologies if I seem a bit harsh but sometimes the strength is not in attacking your foes for your own glory, but in letting the...

TravisDBA (4/23/2012)

---

We all need to keep in mind that while this question was posed to a group of tech people, it affects everyone. Maybe part of our responsibility is...

You'll have to use a CASE statement that first tests if the PatIndex value is greater than zero, and if so use that, and if not, just return the string...

If you select the default, that'll be you. Whatever credential you used to connect to SQL Server with. Usually, your Windows login.

That's a bad idea, because what happens...