Sunday, March 11, 2007

Installing SQL Server 2005

SQL Server includes 5 editions
1. Enterprise edition
2. Standard edition
3.Develeoper edition
4.workgroup edition
5.express edition
1. Enterprise edition has no limitations and has all features and functionality
2. Develeoper edition has no limitations and has all features and functionality, but it is not licensed for production
3. Standard edition has all features and functionality suited for larger data set, but it is limited in the no of nodes(4 processors) it supports for clustering as well as in its capability to use system resources , online indexing, fast recovery, indexing views, online restores and data processing.
4.workgroup edition does not include the features and functionality needed to operate large databases and is restricted in capacity(2 processors) to support mid-size and large companies
5. Express edition is used for small application-installed databases that need to be distributed free of charge. It is not suited for organization-wide databases.

No comments: