Results 1 to 2 of 2

Thread: Performance Issues

  1. 08-30-2007 #1
    mohsin4u
    mohsin4u is offline
    Junior Member
    Join Date
    Mar 2007
    Answers
    1

    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

    Reply With Quote Reply With Quote
  2. 09-24-2007 #2
    vcyogi
    vcyogi is offline
    Junior Member
    Join Date
    Jun 2007
    Answers
    28

    Re: Performance Issues

    You can use temporary table for this issue

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
GeekInterview
Interact