I have fixed all the implicit conversion issues, but this query is still too slow

I have fixed all the implicit conversion issues, but this query still takes atleast 13 mins to return 830 rows.

Plan.pesession (8.3 MB)
avatar image By RichardBrianSmith 97 asked Jun 11 at 01:46 PM
more ▼
(comments are locked)
avatar image Hugo Kornelis Jun 11 at 07:11 PM

Richard, this forum is currently experiencing issues with attachments so your plans are not accessible.

Can you post the plan on another site, then post a link here? (You can use Brent Ozar's site at https://www.brentozar.com/pastetheplan/ if you want to share just the plan, or just about any site that allows you to upload and share any-format binary files if you want to share the full .pesession data)

10|10000 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 50 attachments (including images) can be used with a maximum of 209.7 MB each and 209.7 MB total.

We are Moving!

<p><br></p>

Follow this question

Topics:

x691
x502
x2

asked: Jun 11 at 01:46 PM

Seen: 6 times

Last Updated: Jun 11 at 07:11 PM