I'm back again. From my previous post, I still won't be able to solve the problem as upgrading IE8 to newer version seems not to be a solution. I tried...

Hi Jason,

I ran the report on another machine using IE8; the result is the same. The report froze for a long time but got a result finally.

I tried this...

Hi,

I limits the query to retrieve data only 1000 rows. The report is still be the same. It freeze about 15-20 minutes but returns the result finally.

There is a warning...

Hello Jeff,

I am changing the query as you mention. The performance is getting better. Now I got the Arithmatic overflow error but I think I could handle it.

Thank you for...

Hi Lovell,

I'm doing what you have recommended. Anyway, I'm not sure what is wrong today with the server. The main query is even worse. Anything going on, I'll let...

Hi everyone,

I have attached actual execution plans of main select query and insert query.

The Select query itself retrieves 80826 rows within 3 minutes.

For the Insert query execution plan, I try...

I could find the work around by creating temp tables of two views and then join temp tables together.

The performance improved 100%. I'm not quite understand the reason behind...

I'm new to SQL server. I have no idea how to paste the whole execution plan to this discussion board as both the views are huge sql scripts. Any recommendation,...