Even when NOLOCK or READUNCOMMITTED hints are used, the query acquires a SCH-S...

You can't alter a column that is part of the primary key or that...

Hugo Kornelis (4/30/2013)

---

For WHERE and IF, a logic result of True qualifies, and False and Unknown do not qualify.

For CHECK constraints, a logic result of True or Unknown qualifies and...

SQLRNNR (4/29/2013)

---

Brandie Tarvin (4/29/2013)

---

You know how you tell people over and over again that certain preconditions need to be met in order for a certain piece of code to run...

I had this problem once before, but I was using a slightly different formula for calculating distances between lat/long pairs. Unfortunately, I no longer work for my employer at the...

L' Eomot Inversé (4/23/2013)

---

yes,...

pbarbee (4/18/2013)

---

I have a scheduled job (.Net, WinOS Task Scheduler) which completes shortly after it's called but the SQL work it should accomplish in real time does not happen until...

Lynn Pettis (4/19/2013)

---

I was doing some testing, code below:

<snipped>

Results:

Beginning execution loop

Batch execution completed 10000 times.

----- Using DelimitedSplit/CROSS APPLY -----

CPU(ms): 422 Logical Reads: ...

Hugo Kornelis (4/19/2013)

---

Christian Buettner-167247 (4/19/2013)

---

Hi,

There is one subtle issue with the explanation (and also the MS documentation).

It is not the ROLLBACK that is causing the abort of the batch....

Glad you got what you needed. Thanks for posting back to let us know you...

ChrisM@Work (4/19/2013)

---

Sean Lange (4/18/2013)

---

patrickmcginnis59 10839 (4/18/2013)

Time and again I've read in the news folks absolutely ruin their own lives over dumb forum stuff even when posting under what they perceive...

:hehe: Hopefully, you were billing them by the hour!

ben.brugman (4/16/2013)

---

<snipped>

We want that the user can use his own workflow, for example, the user decides that a new product is needed. He is going to enter the product, but...

GilaMonster (4/15/2013)

---

To expand on that, I've seen a database's performance dramatically decrease after an upgrade from a single processor server to an 8-core with lots more memory. The code was...

[I think what the OP wants is to return only the comma-delimited strings where any one of the values in the string has LEN(value) > 3. If that's the case,...