Difference between revisions of "Editions - MS SQL"
From Hostek.com Wiki
(Created page with "=== 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 rela...") |
|||
| Line 11: | Line 11: | ||
| − | [[Category:Databases]] | + | [[Category:Databases-MSSQL]] |
Revision as of 17:02, 28 June 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.