I did not find anything related to SQL Server yet..

Please pardon my ignorance, can you point me towards the SQL Server Tutorial...

Does that contain SQL Server related tutorials? I don't seem to find any..:w00t:

I have not done in SQL Server 2000, but had performed this in SQL Server 2005 / 2008. In both these versions I had choice to use the SSIS and...

Does your column contains values as Feb 2010, Jan 2010 or the column is a datetime datatype?

Snow

Would you be able to share the code that exists in the SP, may be something in that needs to rewritten or changed..

Look for express edition for SQL Server on Microsoft. It is free to download and since SQL Server is Windows (GUI) based, it would be easier to learn it. You...

More information would lead to any guestimates, at this point, would only ask for checking the Indexes and Stats on those tables/views, mainly on those columns that are used in...

I would prefer the suggestions given by Jeff and Alan.

Partitioning the database might be a possibility only if the Edition is Enterprise Edition.

Understood, but a change in the Authentication Mode would...

Having lower # of CPU's would be one of the reasons, and as Jeff suggested have the Stats updated..

Any reason why it must be changed to Mixed Authentication Mode?

Interestingly, I found the database option "concat null yields null" when set to either True or False, it yields null values only.. unless SET CONCAT_NULL_YIELDS_NULL ON is specified..

I could...

Either you need to be using the Database Snapshots feature.. (There would be performance hit if your db is larger one, and you also need to have Enterprise Edition for...

Agree with Lynn, it's vague to give a straight answer.

If you need to get the jobs on the test server, you could get it back from latest backup of msdb...