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.

wrap your initial query up into a CTE, then select from the CTE where rank in (1,2,3)

If its in the development stages, then you should be able to use perfmon on your development SQL server and identify the counters needed.

Granted this wont give you a true...