SQL Server Express

From Wikipedia, the free encyclopedia

 This article does not cite any references or sources. (January 2007)
Please help improve this article by adding citations to reliable sources. Unverifiable material may be challenged and removed.

Microsoft SQL Server Express is the freely-downloadable and distributable version of Microsoft's SQL Server relational database management system. It offers a database solution specifically targeted for embedded and smaller-scale applications. Unlike its predecessor, MSDE, there is no concurrent workload governor which "limit[s] performance if the database engine receives more work than is typical of a small number of users."[1] It does, however, have a number of technical restrictions which make it undesirable for large-scale deployments, including:

  • Maximum database size of 4 GB per database (compared to 2 GB in the former MSDE). The 4 GB limit is per database (log files excluded) and can be extended in some scenarios through the use of multiple interconnected databases.
  • Hardware utilization limits:
    • Single physical CPU
    • 1 GB of RAM.
  • Absence of SQL Server Agent Service

Although its predecessor, MSDE, was virtually devoid of basic GUI management tools, SQL Server Express includes several GUI tools for database management. Among these tools are:

A relatively late addition to the SQL Server Express product line is a reduced functionality version of SQL Server Reporting Services, but features such as Analysis Services, Integration Services, and Notification Services are only available in the "Standard" edition and higher editions.

[edit] See also

[edit] References

  1. ^ The SQL Server 2000 Workload Governor. MSDN (January 2004). Retrieved on 2007-01-15.

[edit] External links

v • d • e
Microsoft development tools
Development
environments
Expression Studio
Web · Blend · Design · Media · Encoder
Languages and
compilers
Major APIs and
frameworks
Database tools
and languages
SQL services
Other
Source control
Driver development
Languages