I would do the following, create a sql string then execute that once it is built - example:

create PROCEDURE dbo.test

@ListOwner varchar(200),

@Roles varchar(2000)

AS

/*...

Wow ! - I was looking for all this information a while back and never found as much detail as you had managed within the couple of links you had...

I am not sure of the function of your application, but is it worth having several tables that are date related and then just drop the tables that are relevent...

Grats on hitting that mark - Just interested , is this a data warehouse database as opposed to an OLTP one ?

What are the performance and logging implications if the index were to be deleted and recreated - as opposed to defragging? I know that access to the table may be...

I would be vey interested to know how you implemented your cluster solution form an architectural point of view, and what configuration it is in (ie a/a or a/p). I...

Here are a couple of links that may help you navigate your way through the clustering side - I have been working on a similar scenario and there are certainly...

This may not be much help and is more of a backend solution rather than controlled in the reporting services output. when performing the select do something like SELECT TOP...

Well as no-one else has answered here yet - I will add a few things I would look for during a load test.

Does the load affect any other users on...

I have done more research on the location of the Tempdb and it appears there are several recommendations for the area to be located on the shared resources, but none...

Thank for your reply - It has raised more questions so here goes.

Can you explain a bit better why you recommend that the tempdb reside on the shared resources of...