Interview Preparation mode beta
Funny Facebook Status Funny Facebook Status
Enter your email address

Tell something about MS SQL Server

+1 vote
MS SQL Server is a Relational Database Management System developed by Microsoft Inc. Its primary query languages are:

T-SQL.

ANSI SQL.

History:

1987 - Sybase releases SQL Server for UNIX.

1988 - Microsoft, Sybase, and Aston-Tate port SQL Server to OS/2.

1989 - Microsoft, Sybase, and Aston-Tate release SQL Server 1.0 for OS/2.

1990 - SQL Server 1.1 is released with support for Windows 3.0 clients.

Aston-Tate drops out of SQL Server development.

2000 - Microsoft releases SQL Server 2000.

2001 - Microsoft releases XML for SQL Server Web Release 1 (download).

2002 - Microsoft releases SQLXML 2.0 (renamed from XML for SQL Server).

2002 - Microsoft releases SQLXML 3.0.

2005 - Microsoft releases SQL Server 2005 on November 7th, 2005.

Features:

High Performance.

High Availability.

Database mirroring.

Database snapshots.

CLR integration.

Service Broker.

DDL triggers.

Ranking functions.

Row version-based isolation levels.

XML integration.

TRY...CATCH.

Database Mail.
asked 1 year ago in SQL Server Interview Questions and Answers by R (19,530 points) edited 1 year ago by R

Your answer

Email me at this address if my answer is selected or commented on:
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register.

0 Answers

Related questions