Difference between revisions of "Editions - MS SQL"
From Hostek.com Wiki
m (Briana moved page MS SQL to Editions - MS SQL) |
|
(No difference)
| |
Revision as of 00:52, 3 July 2012
MS SQL Databases
What Version of MS SQL should be used?
MS SQL Express can be used in most cases. However, there are a couple of limits to be aware of related to the Express edition.
The Express edition can handle databases up to 4 GB in size. If you need a database larger than 4 GB you will need the Web Edition of MS SQL Server.
The Express edition can only utilize up to 1 GB Ram. If you have a busy database or will have several databases with normal traffic, you will notice a performance improvement with more than 1 GB Ram, in which case you would want the Web Edition.