This set of articles was very informative in a concise manner.    

I would like to see an article on migration issues and things to consider.  We have been running SQL 2000 and I have been using the 2005 Management Studio alternately with the 2000 Enterprise Manager and doing my research into how best to proceed to a migration now that we have made the decision to do so.

There are always gotchas when migrating depending on setup and configuration.  I am going to be migrating SQL 2000 (running on Win 2003 servers) to SQL 2005.  I have done a great deal of research on it.  There are still some questions to hardware configuration for optimization of 2005 that I have found difficult to find any reference to. 

If you were of a mind to do so, I would personally appreciate some Dos and Don'ts for migrating.

Thank you..cherie