I am writing a fairly large program in Visual Basic 2008 with SQL 2005. The databases and the Enterprise manager for SQL 2005 is terribly slow. If I change servers to our SQL 2000 server the performance increase is phenomenal. Why is SQL 2005 so slow?
If you are using a local instance of SQL 2005, it is likely assigning "auto_close" to all of the databases. This impacts performance significantly. Outside of that, I would have your DBA look over the setup of the 2005 server. There are probably hundreds of variables to look at.