I'd say that a plan containing an implicit cast points to a bad query. The plan itself isn't bad (or misunderstood) but the query that generated it is one...

Actually, you can send an email with a NULL body. I'd start with msdb.dbo.sysmail_mailitems. Find your rows where the email is sent and that should tell you where...

Hot

Broken

Peach

ScottPletcher (8/16/2016)

---

Ed Wagner (8/16/2016)

---

ScottPletcher (8/16/2016)

---

Jeff Moden (8/15/2016)

---

ScottPletcher (8/15/2016)

---

Jeff Moden (8/15/2016)

---

ScottPletcher (8/15/2016)

---

Jeff Moden (8/15/2016)

---

Also, you should probably avoid auditing inserts. It's an unnecessary duplication of data because even if there's...

Eric M Russell (8/16/2016)

---

Ed Wagner (8/16/2016)

---

Eric M Russell (8/16/2016)

---

It would be useful to have an experienced gray haired DBA who could offer technical assistance and architectural advice across any number...

Eric M Russell (8/16/2016)

---

It would be useful to have an experienced gray haired DBA who could offer technical assistance and architectural advice across any number of projects, more like an...

ScottPletcher (8/16/2016)

---

Jeff Moden (8/15/2016)

---

ScottPletcher (8/15/2016)

---

Jeff Moden (8/15/2016)

---

ScottPletcher (8/15/2016)

---

Jeff Moden (8/15/2016)

---

Also, you should probably avoid auditing inserts. It's an unnecessary duplication of data because even if there's never an update,...

To the best of my knowledge, once the data is stored in the varchar column, there's no way to translate it into the original Unicode characters. Sure, you could...

Nice question. It illustrates a good point. Thanks.

Chop

Another approach that uses an ITVF, only it uses the EXCEPT set operator instead:

if object_id('dbo.NotPurchased', 'if') is not null drop function dbo.NotPurchased;

go

CREATE FUNCTION dbo.NotPurchased(@UserID Nchar(10)) RETURNS TABLE WITH SCHEMABINDING

AS

...

Hello and welcome to SSC. What error does it throw?

ScottPletcher (8/15/2016)

---

Jeff Moden (8/15/2016)

---

Also, you should probably avoid auditing inserts. It's an unnecessary duplication of data because even if there's never an update, the original data lives in the...