Usually make your primary key the clustered index as that is the unique identifier for the row.

It will degrade performance as when you create a clustered index on a heap...

Can you post the rest of the tables in the query along with test data for each of them

From what I can see, all your tables are heaps.

Is there a reason you dont have CLUSTERED indexes on any of these tables?

The job history table is a cumulative table of all history from all jobs. By default it only stores around 1000 rows in the table, so if you have...

To add on to Gullimeel, please follow the link in my signature on how to post performance problems.

Woohoo, easy 7 points, happy holidays all those in the US

What browser are you running it in?

I would strongly recommend using a calendar table which you can link on to get the results you need.

I will try and find the links to some articles on this...

If this is a brand new requirement and you dont have anything to base your hardware requirements on it is best to ask the people who want the application /...

What do you get from the below query

select log_reuse_wait_desc, name from sys.databases

I think the OP wants to acheive a MCM rather than he already has an MCM as I just checked the MCM list and couldn't find Ramdas in the list.

What is the authentication method? Windows / SQL?

Does the user exisit on Server2? If not you wont be able to connect?

If windows authentication do you have SPN's configured for...

Looks like you want to look at a computed column.

http://msdn.microsoft.com/en-us/library/ms191250%28v=sql.105%29.aspx

In that case I would go down the route of AD groups and get a a copy of RSScriptor to copy the objects from the old server to the new...

then just change the query to match the rank id's you are after.