Popular Posts

  • SQL AVG
    The SQL AVG aggregate function selects the average value for certain table column. Have a look at the SQL AVG syntax: SELECT AVG(Column1) FR...
  • SQL Tutorial
    SQL Tutorial Table of Contents SQL Tutorial Learn what SQL (Structured Query Language) is, and where and how it is used. SQL Table SQL Datab...
  • SQL ALIASES
    SQL aliases can be used with database tables and with database table columns, depending on task you are performing. SQL column aliases are u...
  • SQL SELECT INTO
    The SQL SELECT INTO statement is used to select data from a SQL database table and to insert it to a different table at the same time. The g...
  • SQL AND & OR
    The SQL AND clause is used when you want to specify more than one condition in your SQL WHERE clause, and at the same time you want all con...
  • SQL DELETE
    So far we’ve learnt how to select data from a database table and how to insert and update data into a database table. Now it’s time to learn...
  • SQL SELECT
    The SQL SELECT statement is used to select data from a SQL database table. This is usually the very first SQL command every SQL newbie learn...
  • SQL MAX
    The SQL MAX aggregate function allows us to select the highest (maximum) value for a certain column. The SQL MAX function syntax is very sim...
  • SQL JOIN
    The SQL JOIN clause is used whenever we have to select data from 2 or more tables. To be able to use SQL JOIN clause to extract data from 2 ...
  • SQL IN
    The SQL IN clause allows you to specify discrete values in your SQL WHERE search criteria. THE SQL IN syntax looks like this: SELECT Column1...

Wednesday, March 18, 2009

Limitations of SQL Server Express

SQL Server Express is a free, easy to use, redistributable version of SQL Server 2005 designed for building simple data-driven applications. SQL Server Express has most of the features offered by SQL Server full version, but with certain limitations. This makes SQL Server Express a good choice for small and medium scale applications.

Most of the limitations of SQL Server Express edition will not affect the small/medium scale applications.

Limitations of SQL Server Express Edition
1. Number of CPUs supported

SQL Server Express uses only one CPU at a time. It can be installed on a server with multiple CPUs, but it will use only one CPU at a time.

2. Maximum memory used

SQL Server Express uses a maximum of 1 GB memory for it's data buffer. So, if your server has severaql GB memeory, SQL Server Express cannot take advantage of it.

4. Database size limit

Maximum database size is limited to 4 GB (log file size is not counted)

5. Profiler in SQL Server Express

Profiler tool is not included with SQL Server Express editions.

6. Job Scheduler

Job Scheduling service is not available with SQL Server Express.

7. Import/Export

Data import and export feature is not available with SQL Server Express.

A complete feature comparison of various editions of SQL Server can be found at the Microsoft web site - http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)