You might be running into either blocking/locking issues, or into parallelism issues.

The easiest way to narrow down what to target is to track wait states on the server. You...

Something like this?

SELECT *,

CHARINDEX('#', C),

CHARINDEX('#', C, CHARINDEX('#', C) + 1),

...

Any triggers on the table?

Or possibly a rollback command later in the script?

Revenant (2/25/2012)

---

Grant Fritchey (2/25/2012)

---

LutzM (2/25/2012)

---

<shudder>

It becomes rather scary...

LutzM (2/25/2012)

---

<shudder>

It becomes rather scary when seen in...

Lynn Pettis (2/24/2012)

---

Quite an interesting day. I gave my two weeks notice and was basicly told that I would not need to come back. Not that I don't...

I'm with most here: Scratching my head and going "huh?" on Kevin's situation. Gail's makes total sense. Anything that increases available parallelism can easily increase deadlock and related...

To avoid assuming, I'll ask: Have you set the Delay Validation property on the package and the query object to True?

Also, can you provide it with a "temporary" server name...

Brandie Tarvin (2/23/2012)

---

Steve Jones - SSC Editor (2/22/2012)

---

Brandie Tarvin (2/22/2012)

---

2) WordPress gurus, I'm recreating my website with the WordPress content manager and wondering if I can separate my writing blog...

Only thing I can really suggest at this point is an old-style partitioned table, using a View instead of the table for code access to it, using the old rules...

Had the idea of setting a database to Read Committed Snapshot mode, and trying building an index on a table with some locks on some rows. No joy, still...

Default constraints and triggers alike will both fail to record the correct data if you're using a web front-end that uses things like shared connections, et al.

They will ONLY work...

A very interesting observation on the human mind/spirit is that we can almost all accept that there's room for improvement, but can't accept that this means there are flaws.

It's easy...

GilaMonster (2/22/2012)

---

Jack Corbett (2/22/2012)

---

GilaMonster (2/22/2012)

---

Question for those of you who have organised SQLSaturdays

Would you have been irritated if your regional mentor or an organiser of another SQL Sat...

CELKO (2/21/2012)

---

I...