Nice approach list :w00t:

The "Remain Calm / Keep your head cool / Keep on breathing" should actually be put after every major point.

In case of urgency, that is vital...

It depends !

With an upgraded database, the default schema will be the userid.

This script needs to be executed with sysadmin auth because of the "execute as" and "Revert".

Don't forget to...

As Greg stated, it is an add on component after your sqlserver has been installed.

You can download it from Feature Pack for Microsoft SQL Server 2005 at http://www.microsoft.com/downloads/details.aspx?FamilyId=50b97994-8453-4998-8226-fa42ec403d17&displaylang=en

The component you...

Since partitioning is an advanced topic, it is highly recommendable to read BOL and to read the white paper on partitioning.

(make sure you have the latest version of BOL !)

-SQL2005...

Is you database case sensitive ?

If you enter a default schema for a user, it will nolonger search the way it did in sql2000 !

AFAIK you only need to install the backward components if you want to be able to modify the packages.

Keep in mind to put your DRP for this upgraded server in...

We always have 'sa' for actual db owner.

With application service accounts that created databases and dbobjects..

-On SQL2000 the attitude is like Jerry Hung stated.

-On SQL2005 those db are also altered...

I've also found some nice perf. info at http://www.ramsan.com/products/products.htm

If I get the chance, I'll certainly try it out.

That depends entirely on the "current" economic situation.

Your question wasn't posted completely.

also you'll need to figure out the "fomat" of your integer time column(s).

- are they expressed in seconds ?

- are they just numerical representations of...

how up to date are your statistics ?

(sp_updatestats / dbcc updateusage(0) with count_rows)

Your on SP2 without any cumulative updates. (current is sp3)

Do you see any other messages in your sqlserver errorlog file ?

I would try to start a trace and figure out...

you could opt to compress your .BAK files (zip or rar).

This way you would end up with about 25% of your backup file sizes.

With that volume (1TB) spread your...

Hopping in late ...

I've recently had about the same issue....

http://www.sqlservercentral.com/Forums/Topic678236-21-1.aspx

JohnG and Jacob helped out well.

Jacob Sebastian's article on XML are great.

What service pack are you on ?

Post the results of:

Select @@version

As always, it is acceptable if it serves you good.

I think MS Best practices states a number of 5 or 7.

Here are some nice guidelines on common stuff:

http://technet.microsoft.com/nl-be/library/cc966401(en-us).aspx