Login
Register
All Activity
Questions
Unanswered
Tags
Users
Ask a Question
About Us
986
Questions
785
Answers
Interview Preparation mode
beta
Funny Facebook Status
Enter your email address
All categories
SQL Server Interview Questions and Answers
(197)
SSIS Interview Questions and Answers
(54)
SSRS Interview Questions and Answers
(9)
SSAS Interview Questions and Answers
(29)
.NET Interview Questions and Answers
(186)
Oracle Interview Questions and Answers
(122)
Java Interview Questions and Answers
(32)
UNIX Interview Questions and Answers
(47)
Networking Interview Questions and Answers
(17)
MySQL Interview Questions and Answers
(30)
HR Interview Questions and Answers
(237)
General Interview Questions and Answers
(9)
Other Interview Questions and Answers
(8)
Job Openings
(3)
Greenplum Database Interview Questions and Answers
(5)
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
sql-server-interview-question
database
dbms
rdbms
Your answer
Email me at this address if my answer is selected or commented on:
Email me 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
Nice?
Vote!
Add
Ans!
What are CODD rules?
asked
1 year
ago
in
SQL Server Interview Questions and Answers
by
Pandi
(
540
points)
database
rdbms
dbms
sql-server-interview-question
Nice?
Vote!
Add
Ans!
What is difference between DBMS and RDBMS?
asked
1 year
ago
in
SQL Server Interview Questions and Answers
by
Pandi
(
540
points)
sql-server-interview-question
database
rdbms
dbms
+1
vote
1
answer
What is extension and intension?
asked
1 year
ago
in
SQL Server Interview Questions and Answers
by
R
(
19,530
points)
sql-server-interview-question
database
dbms
rdbms
+1
vote
Add
Ans!
Tell something about MS- ACCESS
asked
1 year
ago
in
Other Interview Questions and Answers
by
R
(
19,530
points)
database
rdbms
access
+1
vote
Add
Ans!
Tell something about ORACLE
asked
1 year
ago
in
Oracle Interview Questions and Answers
by
R
(
19,530
points)
oracle-interview-question
database
rdbms
oracle