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]]