If the links above dont help, Can you give more details where you find the install confusing as that will help people answer your questions a lot quicker.

Andre,

I may help, however there was an article here on SSC (I think it was written by DwainC) on this subject showing the performance of PIVOT/UNPIVOT vs a CROSS TAB,...

Be careful with CTE's they arnt always the best way to go, but try them to see what happens.

You might also get an improved performance by switching the CTE's so...

THe problem you may have is with all the Nested Derived tables.

How many records are being populated into the TEMP tabe as im not sure you need the compound...

As far as im aware a BULK insert causes and Triggers to be ignored, Further Reading: http://msdn.microsoft.com/en-us/library/ms187640(v=sql.105).aspx

I have to say the Unique Key with a database table is usually SCHEMA, TABLE, and COLUMN, as it is possible to have two tables named the same in different...

I agree...

Surely this is because the Outer apply cointains a filter based on the outer table which will cause a rBAR operation as each row has to be evaluated.

The Left...

It looks like table 3 (#C) might be better placed as a TUPLE table where by you have two columns one referencing Table A, the other Table B.

You would then...

David.Lester (6/6/2013)

---

Agreed!

However, I did just start here. I dragged the last place I was in from paper systems to nearly 2010. (It was 2012 when I got them to 2010,...

You might hit an issue with Merge on a large record set.

This is a handy article http://technet.microsoft.com/en-us/library/cc879317.aspx and gives some advice on indexes, and stats to look at when tuning...

I completely Agree about the indexes being the real issue I've been looking at this script to see what the Engine says it needs, then looking at creating covering indexes...

I know, and this isn't the worst query, one of them had a 1.2 million Sub-tree cost at the root.

This particular query is used in a view...

Thanks Chris,

I was looking at an NC index on SectionId, with an includes of the InceptionDate, but the benefit is minimal (based on an Index benefit analysis).

a little bit...

Another good article is this one https://www.simple-talk.com/sql/database-administration/gail-shaws-sql-server-howlers/ by Gail Shaw.

If you are considering doing this simply to try and increase the performance of queries you need to have a rethink,...