The most expensive operation by far is the sort before the aggregation. I'd like to see what happens if you force a HASH MATCH for the aggregation. Can...

Rod at work (2/10/2012)

---

OK, right off I've got to tell you that I'm not familiar with Report Server Configuration Manager.

So, I got into it on the report server. On...

Can you post the execution plan for the group by?

Are you developing on the same machine as the report server is on?

Are you connecting to a remote SQL Server or one on your local machine?

Can you connect to the...

What do you see when you go into Report Server Configuration on the report server? That should tell you what the URL's are setup as and if you have...

Yeah it's not a performance issue,...

I haven't used TDE or really any encryption in SQL Server. I prefer to have column level encryption done at the application level. I like the fact that...

sherifffruitfly (2/10/2012)

---

Friend of mine told me to order my joins so that the greatest expected number of rows are eliminated soonest. Unfortunately, I've never been clear on just how to...

Yes you can use the script I just provided to load the data into a table, but you can do all the analysis you need without using a table by...

You should leave the XACT_STATE in but change it to XACT_STATE() <> 0. It is a best practice to check to make sure the transaction is available to be ROLLED...

I don't...

Daniel Bowlin (2/10/2012)

---

So I read the article and ran the query for missing indexes ordered by performance impact.

The first 4 missing indexes were for the same table. Take...

Good article. I would only mention that in order to fix ordering issues you don't necessarily need to change the clustered index. ALL indexes are sorted, so a...

Seeing your query I don' think your main problem is the CASE statement included in the GROUP BY, I think it more likely related to your CROSS JOIN's to the...

Good...