Can anyone suggest me an idea please.

So is there no way out of this mess? Is it possible to have a new table with same structure with a computed column where we do a bulk load...

GilaMonster (6/2/2016)

---

Will it really?

UPDATE...

GilaMonster (5/25/2016)

---

See if this helps, since you don't need anything from the temp_eligibility table other than the row match, there's no point in a join

UPDATE eligibility

SET primary_plan = 0

WHERE EXISTS...

Jeff: "All the MAXDOP hint is doing is allowing it to consume as many resources as it wants. If it used all CPUs for a full second, would that...

Dear All,

Today while running the procedure in its original form, which takes around 10 seconds to output 100 rows for a particular set of parameters, I opened a new query...

Sergiy (3/23/2016)

---

Every query has a common block:

FROM dbo.RequestorToCapabilityDeferred_vw r

INNER JOIN dbo.Capability_tbl c ON r.capabilityId = c.capabilityId

LEFT OUTER JOIN dbo.CapabilityStatus_tbl CS on r.capabilityStatusid = CS.capabilityStatusid

It should be made...

Lowell\Chris- As per Lowell's advice I created smaller procedures and attaching the new plan. however, as Jeff pointed out those hash and merge join fat pipes appearing again. Not sure...

As per Lowell's suggestion, I tried to create stored procedures but on lower env. the build team started the refresh so I am waiting to finish them in 2-3 hours....

ChrisM@Work (3/21/2016)

---

chandan_jha18 (3/21/2016)

---

Thanks Lowell. The NULL and the Or clause are business rules so won't be able to find my way around that.

I will try breaking the master proc and...