Indianrock (12/9/2016)

---

Yes, yes and yes. And correct me if I'm wrong, but once the front end of a plan ( right side as viewed in an execution plan...

Brandie Tarvin (12/9/2016)

---

rodjkidd (12/9/2016)

---

ChrisM@Work (12/8/2016)

---

rodjkidd (12/7/2016)

---

Eirikur,

I'm about a 20 minute walk to the High Holborn Caffe 1882. Let me know if you still want to meet up today?

Chris, are you...

rgp151 (12/8/2016)

---

Here is a plan where its just the query encapsulated in SELECT * FROM ()

Remember, if I run just the part inside the outer nesting it runs in under...

"This query was written by a tool". ORM tools can only go so far and this query goes way beyond that. It's unwieldy, inefficient and difficult to engineer into a...

You could accelerate it by saving off DedupedSet as a temp table and indexing it - a clustered index on column A, possibly.

Recursion would usually be used for this Richard.

Try the following:

IF 0 = 1 BEGIN; -- Knock up some sample data

WITH MyData (A, B) AS (

SELECT 'ProdA', 'ProdB' UNION ALL

SELECT 'ProdB',...

moosamca (12/9/2016)

---

Hi All,

COuld you please help me to tune the below query. I have attached the query plan of this query. Its going ont he nested loop and its cost...

drew.allen (12/8/2016)

---

Peter Brinkhaus (12/8/2016)

---

You have to test it yourself if it performs better, but here's simplified alternative:

SELECT

Q.memid,

Q.EffectiveDate,

Q.termdate,

...

Thom A (12/8/2016)

---

...On the side note, I do get a LEFT SEMI JOIN when doing to following:

USE DevTestDB;

GO

CREATE TABLE Jobs (JOBID INT IDENTITY(1,1),

...

rgp151 (12/8/2016)

---

Yeah, I know its a lot. My main question is just what would cause performance to degrade so much just going from:

SELECT

x,

y,

z

FROM

...

rgp151 (12/8/2016)

---

Here is a plan where its just the query encapsulated in SELECT * FROM ()

Remember, if I run just the part inside the outer nesting it runs in under...

Thanks for the feedback Paul, but it's really for Phil and Thom, who did all the...

Phil Parkin (12/8/2016)

---

First thing I'd suggest is removing this line:

INNER JOIN dbo.Drops D ON J.JobID = D.JOBID

As it...

Thom A (12/8/2016)

---

That statement should have very little effect...

rgp151 (12/7/2016)

---

I have a large aggregation query on a large dataset that run forever and never return, but if I run the main part of the query by itself it...