What would you suggest "sql server 2000 enterprise edition" or "sql server 2005 express edition"?

Is a big difference between these 2 programs in case of performance

The SQL Server 2005 Express Edition is designed for small databases. It is a limited subset of the full SQL Server 2005. It has one major advantage. It's FREE. It can also be easily upsized to full SQL Server 2005 - of course that will cost you some money. SQL Server 2005 Express Edition is the replacement for the MSDE.

Rand

I know that theres "some" difference, but i'd like to know if it is that much

I also found that http://www.microsoft.com/sql/prodinf...-features.mspx

There memory and processor limitations, and some big performance hits once you start getting to a fair number of users hitting the database concurrently. I won't put more than 10 to 20 users on Express.



Scott Klein
Author - Professional SQL Server 2005 XML
http://www.wrox.com/WileyCDA/WroxTit...764597922.html

What about 2000 enterprise and 2005 enterprise in there a big difference?

If I were starting out today, building a new database server, I would use SQL Server 2005. There are "differences", almost all of which are enhancements. If you are used to SQL Server 2000, you will not find SQL Server 2005 to be a "strange new world", however you will find that it is easier to do some things in SQL Server 2005 which required a lot of work to accomplish in SQL Server 2000.

For example: You can now parameterize a "SELECT TOP @n" statement instead of having to create dynamic SQL to accomplish the same task.

The new SQL Server Management Studio (2005) replaces both Enterprise Manager (2000) and Query Analyzer (2000) - (you no longer have to open both at the same time), however it does it at a memory cost as compared to having only one of the tools open.



Rand

If you want to "try out" the SQL Server 2005 Express Edition, I recommend "Wrox's SQL Server 2005 Express Edition Starter Kit", which is a cost effective (generally under $30 US) way to do it.

One caveat - I recommend downloading SQL Server 2005 Express Edition and Visual Basic 2005 Express Edition from Microsoft's web site rather than loading the software from the DVD, that way you will get the latest service packs and some newer features.

Rand