SQL Server 2005 Express facts
I have been getting alot of questions about this topic, the most frequent question is why should we use SQL Server 2005 Express over the standard or enterprise edition? what is exactly SQL Server 2005 Express?
Well, I can’t possibly put all the details in this article, but here are some facts that you should know:
1) SQL Server 2005 Express Edition is free, no cost associated with downloading or installing it on your machine.
2) The Express version of SQL server 2005 replaces the MSDE in SQL Server 2000 with an interface that allows you to interact with the database.
3)SQL Server 2005 Managment Studio Express allows you to build, manage and maintain databases easily.
4) SQL Server 2005 Express Edition has no workload governor.
5) Database Size limitation on SQL Server 2005 Express is 4 GB and RAM support is 1 GB.
Those are 5 basic Facts about SQL Server 2005 Express, so now you know its not a trial or a shareware to SQL Server 2005, its a stripped down version of SQL Server that works great for someone who wants to build small databases and applications, or wants to create a sandbox or a test bed of some sort.
Jun 24th, 2008 at 8:48 pm
[...] Technorati Search for: databases wrote an interesting post today onHere’s a quick excerpt I have been getting alot of questions about this topic, the most frequest question is why should we use SQL Server 2005 Express over the standard or enterprise edition? what is exactly SQL Server 2005 Express? Well, I can’t possibly put all the details in this article, but here are some facts that you should know: 1) SQL Server 2005 Express Edition is free, no cost associated with downloading or installing it on your machine. 2) The Express version of SQL server 2005 replaces the MSDE [...]