Even wondered what different wait types in sysprocesses mean and what are typical values of various performance monitor counters. Here is an article from Microsoft that correlates them and suggests courses of actions for different scenarios.
SQL Server Books Online provides details about various migration option. The following document shows 10 steps process of migrating SQL Server 2000 databases into SQL Server 2005 and post migration steps.
SQL Server Management Studio provides a wizard to generate script out of a database. But it would be nice if we can automate the process so that database script is generated and stored somewhere.