Chris Harshman (12/13/2016)

---

Kindly read this join as below :

from dbo.EOS_Reports c...

Chris Harshman (12/7/2016)

---

I notice you've rewritten part of the stored procedure, USP_ICMExtendedSummaryReport_Temp, now has:

...

from dbo.EOS_Reports c with (nolock)

INNER JOIN #TempUserAccess T on T.AccessID = c.OrgPathID AND T.AccessType = 'NONSHARED'

where

...

Chris Harshman (12/6/2016)

---

sqlandbiuser (12/6/2016)

---

Procedure is still slow and taking more time for more records.. For 150K records, given select proc takes more than 10 mins to get the data.

Any...

Procedure is still slow and taking more time for more records.. For 150K records, given select proc takes more than 10 mins to get the data.

Any further inputs will...

Chris Harshman

I'd agree with Sean here, the first thing is to replace that splitter function you're using, and preferably only parse the strings once. If you need to get...

Chris Harshman

OK looking at the whole stored procedure code (I could only see part of it using the sqlplan file), I can see that the second part of the...

When considering how SQL Server uses indexes, the order of the columns in the index matters. Since you said the clustered index definition is (InstanceId, OrgID, Sharedid), and OrgID...

@SSCrazy- Thanks for these valuable inputs..

fn_SplitString - This function is used to split the pipe delim. parameters being passed from multi-select dropdown boxes, and we have 5 such parameters. As...

Thank you Gail. I've got hint on next steps. I'll come back if I need more help on moving data.