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