It's not clear what you are trying to do.

There's a Derived Column transformation. Do you mean a computed column?

Glad to hear it, and glad things are going well.

Love to see a card trick if we end up at the same...

Lowell (2/27/2013)

---

Steve Jones - SSC Editor (2/27/2013)

---

Haven't seen a lot on it. I know Adam Machanic and a few people use it, but don't see much written.

I did run across...

You could call a remote stored proc and return values back. That might allow you to use OUTPUT on the remote side, and then when it returns, insert those into...

Stefan Krzywicki (2/27/2013)

---

I haven't done anything with CLR in a few years. Now I need to create JSON files and CLR looks like the best way. Anyone have a link...

You definitely will get implicit conversions, which can be a huge slowdown. I'd fix this first.

The plan shows that the inserts to the AuditLog table, and then the full text...

Great articles Gail linked to. I'd tend to do this monthly, but YMMV.

You can use PATINDEX or CHARINDEX to do this. Here's a sample: http://www.sqlservercentral.com/articles/String+Manipulation/94365/

paul.knibbs (2/27/2013)

---

Being serious about this, it's not like the first time Microsoft has flailed around trying to find the current zeitgeist in order to follow it and then dominate it--remember...

About 2-4" of snow last night, but blowing hard. I have 2-3 ft sandbars in the driveway.

School cancelled.

I think...

GRE (Gethyn Ellis) (2/27/2013)

---

I read an interesting piece a while - It was posted on Twitter (I can't find the link). It called for Ballmer to go basically saying he...

mark.fisher (2/27/2013)

---

Given the current state of the economy can you blame them for having a more business orientated focus. MS have been concentrating on core products, probably with a...

Nothing against Win 8. To me, it's really Win 7 with...

Are you inserting to a remote table and trying to log it locally?