SQL Server Express Edition is the free version of Microsoft SQL Server, and is a replacement for MSDE. It has almost all the features of the other versions of SQL Server. There is a common misconception that it is limited in terms of the number of connections it can accept. I am pretty sure this is something that people think because it used to be true of MSDE. It does have some limitations, however, including : -
- Only supports 1 CPU (although it won’t break if you put it on a multicore/multiprocessor system)
- Won’t use more than 1GB RAM
- Databases can’t grow to more than 4GB
This is fine for most jobs, but obviously if you have a really busy or big system then you’ll need to go for a higher edition or another alternative.
No related posts.