GilaMonster (9/23/2013)

---

And now that the paperwork has been signed....

November it's good bye consulting, back to full time grind. Starting at a software development house as a technical lead. Focusing on...

2 possible solutions:

1. Computed Column in dbo.ReportSchedules with an index that you the use in your comparison. With the sample data it doesn't get used but with a...

I agree with pietlinden. Assuming your SP that returns a job type (or types) doesn't have any complex logic in it I would implement any parameters passed to usp_RPT_HSG_JobType in...

Brandie Tarvin (9/19/2013)

---

Thanks, Jack.

Huh. Apparently the Key Lookup shook itself out of the execution plan a bit later on. Now I've got Clustered Index Scans.

Of course, I've been playing with...

Need more information. Can you post the query? It sounds like you aren't getting the results you are expecting back from the query.

If you were to share the DDL for the table (or an example) and the conditions you want it would it easier to help you out.

Michal has shared one possible...

Can you share the DDL for the Xevent session you created? Perhaps you aren't capturing the data you need to capture.

I don't think that there is anyway to have and SSRS report export to Excel and have the spreadsheet have drop-down's. I'm pretty sure you'll need to find another solution...

Does this server have access to the internet?

Make sure you are using port 587 and that you are using SSL and basic authentication. Also verify that your user name...

In my experience, key/bookmark lookups are not usually a good thing. Basically this says that the index being used to filter the data cannot return all the columns needed...

You may need to play around with it so that each set of Q & A are a group.

Stefan Krzywicki (9/18/2013)

---

Koen Verbeeck (9/18/2013)

---

Stefan Krzywicki (9/18/2013)

---

Am I wrong in saying we shouldn't be using

SELECT * INTO #A1 FROM Table

SELECT * INTO #B1 FROM #A1

in production code? #A1 & #B1...

That query is being run 8000 times. What is the duration of the trace you are running?

The fact that is says .NET Sql Client is the application means someone...

If you have it in a group (details are a group) you can say Keep Together.

You need to get rid of the single-quotes and replace the @ with a :. Check out this blog post