It may not be relevant here, but ...

Presumably you are aware of all of this[/url] stuff regarding the new cardinality estimator.

Can you answer Gail's question?

Use SSIS and throw away your linked server 🙂

Thanks! And here is the link again, for lazy clickers:

http://blogs.msdn.com/b/sqlreleaseservices/archive/2015/04/16/sql-server-2014-service-pack-1-has-released.aspx

marc.heidemann (4/16/2015)

---

Notice: The SQL SSIS team has found an issue with SP1 installation if SSIS catalog is present in the SQL Server instance.They are currently investigating this issue including possible...

Can you include the proper DDL, as generated in SSMS?

Also, you have not asked a question, leaving us to guess.

Both of the plans look fairly...

jackimo (4/15/2015)

---

Thanks for all the replies.

I tried Phils suggestion of the not exists with the select 1 and I get 0 rows returned.

I'm expecting 2 rows.

I also tried MadAdmins edits...

As an aside, you will find that your SQL becomes more readable if you use meaningful aliases.

NOT EXISTS would possibly help:

select m.lID

from Message m

join Message_Cc mCC on m.lID = mCC.lMessage

...

Your question is difficult to read. Can you reformat it to make things clearer?

Actually, this version should be faster:

select * from @SAMPLE_DATA sd

where @strname like sd.SD_TEXT + '%'

select * from @SAMPLE_DATA sd

where @strname like '%' + sd.SD_TEXT + '%'

Ville-Pekka Vahteala (4/14/2015)

---

These did not have those numbers what I asked, but they...

That link does not work for me.