Editions - MS SQL

From Hostek.com Wiki
Revision as of 17:02, 28 June 2012 by Briana (Talk | contribs)

Jump to: navigation, search

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.