Performance Tuning
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 2000 to SQL Server 2005 Migration
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.
Generating Database Objects Scripts in SQL Server 2005
How many times you have been asked by a developer if you can recover a stored procedure or a table structure because he/she made a change in existing environment. In a perfect world all SQL code including database objects must be in a source control tool, but in most of the places database schema is not part of it as it is little cumbersome to include it.
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.
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.