Microsoft SQL Server: Difference between revisions

Revision as of 17:16, 3 September 2015

Revision as of 20:13, 4 September 2015

Line 1:

{{Infobox software

| name = Microsoft SQL Server

| logo =

| screenshot =

| caption =

| programming language = [[C (programming language)|C]], [[C++]]<ref name="Lextrait" />

| developer = [[Microsoft]]

| latest release version = SQL Server 2014

| latest release date = April 2014<ref name="2014-release" />

| operating system = [[Microsoft Windows]]

| platform = [[IA-32]]or

″≠≤≥±−×÷←→·§[[.NET Framework 3.5]]<ref name="Hardware and Software Requirements" />

| genre = [[Relational database management system]]

| status = Active

| language = English, Chinese, French, German, Italian, Japanese, Korean, Portuguese (Brazil), Russian, Spanish and Indonesian<ref name="Download Microsoft SQL Server 2008 R2" />

| license = [[Proprietary software]]

| website = http://www.microsoft.com/sqlserver/

}}

'''Microsoft SQL Server''' is a [[relational database management system]] developed by [[Microsoft]]. As a [[database server]], it is a [[software product]] with the primary function of storing and retrieving data as requested by other [[software application]]s which may run either on the same computer or on another computer across a network (including the Internet).

Microsoft markets at least a dozen different editions of Microsoft SQL Server, aimed at different audiences and for workloads ranging from small single-machine applications to large Internet-facing applications with many [[concurrent user]]susers.

SQL Server uses as its primary [[query language]]s [[T-SQL]] and [[ANSI SQL]]{{citation needed|reason=MS SQL Server doesn't compliance even with SQL-92, you can simply check by yourself|date=July 2015}}.

Line 142 ⟶ 123:

Since the release of SQL Server 2000, advances have been made in performance, the client IDE tools, and several complementary systems that are packaged with SQL Server 2005. These include:

* an [[Extract, transform, load|extract-transform-load (ETL)]] tool (SQL Server Integration Services or [[SQL Server Integration Services|SSIS]])

* a [[SQL Server Reporting Services|Reporting Server]]

* an [[OLAP]] and [[data mining]] server ([[Microsoft Analysis Services|Analysis Services]])

Line 155 ⟶ 136:

SQL Server 2005 introduced Multi-Version Concurrency Control. User facing features include new transaction isolation level called SNAPSHOT and a variation of the READ COMMITTED isolation level based on statement-level data snapshots.

SQL Server 2005 introduced "MARS" (Multiple Active Results Sets), a method of allowing usage of [[database connection]]sconnections for multiple purposes.<ref name="MARS" />

SQL Server 2005 introduced DMVs (Dynamic Management Views), which are specialized views and functions that return server state information that can be used to monitor the health of a server instance, diagnose problems, and tune performance.<ref name="Dynamic Management Views and Functions"/>