Thread: Performance Issues

Hi!
Now a days im facing some performance issues in the SQL Server 2005. We use reporting services and also made some stored procedures but the thing is that most of the queries have been combined with UNION ALL operator.

Can anyone tell me whats the better way to optimize the performance by removing the UNION ALL.

Thanx

You can use temporary table for this issue