Just a hunch...I reckon the WHERE clause inside the EXISTS check should look like this:

WHERE --ISNULL(BK2.CustomerLoyaltyNumber, 'Null') <> 'Null'

--AND BK2.Basket_id = BK.Basket_id

--AND

BK2.CustomerLoyaltyNumber = BK.CustomerLoyaltyNumber

Jeff Moden (12/21/2016)

---

High Jason...

Yes. The old article is what I was talking about. Hadn't seen the new one. Unfortunately, I'm like a lot of humans in that...

skb 44459 (12/21/2016)

---

We issue the following command to reindex the table.

DBCC DBREINDEX ('job', '', 80 )

Sometime this process is stuck until we resolve the blocking issue.

Is there a way...

Hey Richard, if you post up your rCTE version, I'll figure out an index or two for you. rCTE's can be blazingly fast if the indexing is correct.

smw147 (12/21/2016)

---

OOPs, that's my fault, ignore the commas at the end (i've edited my above post now)

The __clients and __entity_asset tables have no indexes. They get created by a...

smw147 (12/21/2016)

---

I think i've figured this out. The execution plan suggested the JOINs were the issue so I asked for the TSQL code.

He's got the following no no's as far...

The nested-cursor approach in your code is likely to underperform, in addition to increasing the complexity of a very simple operation. You can almost certainly simplify your code to something...

You're passing too many parameters to the FORMATMESSAGE function.

For /*---CCR Data Set---*/, you're passing in msg_string as the first argument, followed by 21 param_values. The maximum number of param_values...

Grant Fritchey (12/20/2016)

---

ChrisM@Work (12/20/2016)

---

Grant Fritchey (12/20/2016)

---

ChrisM@Work (12/20/2016)

---

Grant Fritchey (12/20/2016)

---

No, Friday night. The costume ball.

Have they announced...

Grant Fritchey (12/20/2016)

---

ChrisM@Work (12/20/2016)

---

Grant Fritchey (12/20/2016)

---

No, Friday night. The costume ball.

Have they announced a theme yet...

Apparently...

Yeah I know but at least there's this.

Abdallah.mehdoini (12/19/2016)

---

The lazy writer process periodically checks the available free space in the buffer cache between two checkpoints. If a dirty data page (a page read and/or modified) in the...

Try ROW_NUMBER(). Comment out the outer WHERE clause to see how all rows are numbered:

SELECT *

FROM (

SELECT

*,

rn = ROW_NUMBER() OVER(PARTITION BY ProductId, ObjectId ORDER BY CheckNumber DESC)

FROM EuroLuxProductBE.dbo.pdt_multidimensions...

simon.oakes (12/16/2016)

---

1st Example:

Select * from customers where country != 'US' AND country !='UK'; --Works

Select * from customers where Not(country = 'US' OR country ='UK'); --Works because criteria within the NOT...