There are three versions available
The main difference is licensing. Enterprise edition allows MS fail over functionality (very weak solution), lesser editions don't. It also allows more memory, cpu's, etc. Most people use Standard Server edition for production, and the developer edition for their development. Go to MS web site to see the latest and detailed licensing differences.