Hi there,
How do you create your reports? Using T-SQL or Stored Procs? When I create any type of reports, I always use SP's, as they are pre-compiled in the database and thus will perform better. Either way, if you want, you can have "SET NOCOUNT ON" before your query, that will force SQL not to count the number of rows returned, which will give you a little more performance.
Another method I know of (although it is a little risky), is to use "WITH (NOLOCK)" on your table joins, that will tell SQL not to place a lock on the data when reading it. The biggest risk here with this is that you could get a "dirty read", i.e. inaccurate data, especially if the table is prone to CRUD operations a lot. I always use "WITH (NOLOCK)" with lookup or parent tables (such as classifications, etc) to increase the speed.
Another way is to try to minimize any inner queries you may have. They put a lot of strain on the database. Rather see if you can't use a user-defined function instead of the inner query
That's my 2c. Hope it helps!!!!
The H.......
The Question is the Answer, and the Answer is the Question!