Friday, July 13, 2007

SQL Server sample databases

While it is wise to delete sample databases from a production environment, don't delete them from your development environment.

Why?

Because, one day you are going to be looking for a way to do something you have never done before, some strange type of query, perhaps. If you are lucky you will find an example (on-line, or maybe in a book). The chances are that the example will be against one of the sample databases. If you haven't got the sample database any more, the example is no good to you.

The space you gain by removing sample database is minimal. If you are running out of space on a development machine, you will likely have bigger issues than a few small sample databases.

Keep samples, you may need them one day.

1 comment: