You're welcome.

I don't think they've had a service pack for R2 yet. I could be wrong, but I don't think it's applicable.

The original question includes a time warp. If so, I'd work like crazy to prevent WW I, or at least mitigate it. I can think of several possible...

Am I correct that this table does not have a clustered index nor a primary key?

That seems to be what you're describing.

If so, that's probably a major part of your...

Yes, this is a classic double-hop issue.

First, I recommend moving this out of a trigger and into a queued process. The trigger will cause problems because of transactionality. ...

Lynn Pettis (10/28/2010)

---

jcrawf02 (10/28/2010)

---

Two comments, which are completely separate, and I should probably post separately, but I'm lazy 😀

1 - we're all talking too much about Celko, and frankly, you're...

Jack Corbett (10/28/2010)

---

Stefan Krzywicki (10/28/2010)

---

Craig Farrell (10/28/2010)

---

Think this would be a bit much as my signature?

CREATE TRIGGER trg_Celko ON vw_SSC_PostList FOR AFTER INSERT

AS

-- Go read the documents, inline comments are...

Craig Farrell (10/28/2010)

---

Sadly appropriate. Why...

I could be wrong, but it looks to me like this could be turned into a single, moderately complex, query. I'd need table definitions and some sample data to...

GilaMonster (10/28/2010)

---

Craig Farrell (10/28/2010)

---

Hm, with all the Star Wars avatars around here I'm going to have to dig up a few Star Trek ones.

I believe the Picard Facepalm will be...

Here's an example of querying the XML column if you just log the whole function result like I do:

SELECT

LogEntry.value('(/EVENT_INSTANCE/EventType/text())[1]', 'varchar(100)') AS EventType,

LogEntry.value('(/EVENT_INSTANCE/LoginName/text())[1]',...

Jeff Moden (10/29/2010)

---

Paul White NZ (10/27/2010)

---

Jeff Moden (10/27/2010)

---

Steve Jones - SSC Editor (10/27/2010)

---

Some of the smaller manufacturers aren't careful. In the 90s we had two separate NICs have duplicate MACs...

Ron Porter (10/27/2010)

---

Steve Jones - SSC Editor (10/27/2010)

---

When I was going in IT, if you could spell VB, you COULD get a job. If you could get a few letters...

jcrawf02 (10/28/2010)

---

trying to figure out what I *should* be doing to be most efficient when I want to go digging through some of our data. Don’t know if there are...

Toby Harman (10/27/2010)

---

I'd have to say, with all due respect to the various posters before me, that being a Senior DBA is not a matter of whether you use the...