SQL Server Express
5202979
224529080
2008-07-09T07:27:49Z
Stormie
20772
revert - this has nothing to do with SQL Server Express specifically, just an ad for a product that can use SQL Server Express (amongst other DBs)
{{Unreferenced|date=January 2007}}
'''Microsoft SQL Server Express''' is the freely-downloadable and distributable version of [[Microsoft]]'s [[Microsoft SQL Server|SQL Server]] [[relational database management system]]. It offers a database solution specifically targeted for [[Embedded system|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."<ref>{{cite web |url=http://msdn2.microsoft.com/en-us/library/Aa224554(SQL.80).aspx |title=The SQL Server 2000 Workload Governor |publisher=[[MSDN]] |month=January |year=2004 |accessdate=2007-01-15}}</ref> 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:
* [[SQL Server Management Studio Express]]
* SQL Server Configuration Manager
* SQL Server Surface Area Configuration tool
* SQL Server [[Business Intelligence Development Studio]].
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 [[Microsoft Analysis Services|Analysis Services]], [[SQL Server Integration Services|Integration Services]], and [[SQL Server Notification Services|Notification Services]] are only available in the "Standard" edition and higher editions.
==See also==
*[[SQL Server Compact]]
*[[Microsoft SQL Server]]
*[[Windows Server System]]
*[[List of relational database management systems]]
*[[Comparison of relational database management systems]]
==References==
<references />
==External links==
*[http://www.microsoft.com/sql/editions/express/default.mspx SQL Server 2005 Express Edition product page at microsoft.com]
[[Category:Database management systems]]
[[Category:Microsoft server technology]]
{{MS DevTools}}
[[es:SQL Express Edition]]