SQL Server Express

SQL Server Express

Microsoft SQL Server Express, a freely downloadable and distributable version of Microsoft's SQL Server relational database management system, comprises a database specifically targeted for embedded and smaller-scale applications.

Contents

Capabilities

Unlike its predecessor, MSDE, it lacks a concurrent workload-governor to "limit performance if the database engine receives more work than is typical of a small number of users."[1] It has a number of technical restrictions (which make it unsuitable for some large-scale deployments) including:

  • Maximum database size of 4 GB per database (10 GB for SQL Server Express 2008 R2;[2] compared to 2 GB in the former MSDE). The limit applies per database (log files excluded); but in some scenarios users can access more data through the use of multiple interconnected databases.[citation needed]
  • No SQL Server Agent service[3]
  • Hardware-utilization limits:
    • Single physical CPU, but multiple cores allowable[4]
    • 1 GB of RAM (runs on a system with any RAM amount, but uses only at most 1 GB)

Although its predecessor, MSDE, generally lacked basic GUI management tools,[5] SQL Server Express includes several GUI tools for database management. These include:

Features available in SQL Server "Standard" and better editions but absent from SQL Server Express include:

Variants

Microsoft makes SQL Server Express available as:

  • An integrated edition with management tools
  • Core database-engine only
  • A SQL Server Express with Advanced Services edition (first introduced relatively late in Q2 2006 compared to the original release) with a reduced-functionality version of SQL Server Reporting Services and with full-text search capabilities

In the Free 2005 Express version, for example, a standard approach to installation options was provided (as follows). Generally the SQL 2005 Express installers are packaged with the following consistent naming convention:

SQLEXPR.EXE
Has installers for BOTH 32-bit & 64-bit processors, but is a basic install
SQLEXPR32.EXE
Has ONLY the installer for 32-bit processors (still the basic install)
SQLEXPR_ADV.EXE
Has the basics AND SQL Server Management Studio Express (SSMSE) + Reporting & Full Text Queries
SQLEXPR_TOOLKIT.EXE
Has the basics and SSMSE and Business Intelligence Development Studio (BIDS)

These optional variants have gone through several service packs, and each SP installer can be used without using the older ones first:

  • Originals of the above files all carry the version number 9.0.1399.6
  • Service Pack 2 (SP2) versions all carry the version number 9.0.3042
  • Service Pack 3 (SP3) versions all carry the version number 9.00.4035
  • Service Pack 4 (SP4) versions all carry the version number 9.00.5000

Whilst the naming and versioning has been very consistent and simple, many reports exist on the web of major installation problems, which in some cases can be traced back to using installers of different names and versions to attempt to install only parts of what they provide. This results in apparent partial installation failures. In general the best approach is to uninstall an older service pack completely and then reinstall all that is needed from the appropriately named file of the latest SP.

See also

References

External links


Wikimedia Foundation. 2010.

Игры ⚽ Поможем сделать НИР

Look at other dictionaries:

  • SQL Server Compact — Filename extension .sdf Developed by Microsoft Type of format Relational database Microsoft SQL Server Compact (SQL CE) is a compact relational database produced by Microsoft for applications that run on mobile devices and desktops. Prior to the… …   Wikipedia

  • SQL Server Compact Edition — (первоначальное название SQL Server Everywhere) новый продукт компании Майкрософт в линейке SQL Server, являющийся версией SQL Server Mobile со снятым запретом работы под Win32 и изменённой лицензией. Продукт выпущен 11 января 2007 года. SQL… …   Википедия

  • SQL Server Everywhere — SQL Server Compact Edition (первоначальное название SQL Server Everywhere) новый продукт компании Майкрософт в линейке SQL Server, являющийся версией SQL Server Mobile со снятым запретом работы под Win32 и изменённой лицензией. Продукт выпущен 11 …   Википедия

  • SQL Server Compact — Edition (первоначальное название SQL Server Everywhere) новый продукт компании Майкрософт в линейке SQL Server, являющийся версией SQL Server Mobile со снятым запретом работы под Win32 и изменённой лицензией. Продукт выпущен 11 января 2007 года.… …   Википедия

  • SQL Server 2005 Express Edition — Microsoft SQL Server Desktop Engine MSDE est l acronyme de Microsoft Data Engine, Microsoft Desktop Engine ou Microsoft SQL Server Desktop Engine. Il s agit d une édition limitée mais gratuite de Microsoft SQL Server. En 2005, lors de la sortie… …   Wikipédia en Français

  • SQL Server 2005 — Microsoft SQL Server Тип Реляционная СУБД Разработчик ОС Microsoft Windows Версия 2008 6 августа 2008 Лицензия …   Википедия

  • SQL Server 2008 — Microsoft SQL Server Тип Реляционная СУБД Разработчик ОС Microsoft Windows Версия 2008 6 августа 2008 Лицензия …   Википедия

  • SQL Server 2000 — Microsoft SQL Server Тип Реляционная СУБД Разработчик ОС Microsoft Windows Версия 2008 6 августа 2008 Лицензия …   Википедия

  • SQL Server Management Studio — Microsoft SQL Server Management Studio showing a query, the results of the query, and the Object Explorer pane while connected to a SQL Server database engine instance. SQL Server Management Studio is a tool included with Microsoft SQL Server… …   Wikipedia

  • SQL Server Management Studio — SQL Server Management Studio  утилита из Microsoft SQL Server 2005 и более поздних версий для конфигурирования, управления и администрирования всех компонентов Microsoft SQL Server. Утилита включает скриптовый редактор и графическую… …   Википедия

Share the article and excerpts

Direct link
Do a right-click on the link above
and select “Copy Link”