SQL Server Performance
SQL is Structured Query Language. SQL is basically a database language primarily designed for managing and manipulating data in DBMS or RDBMS.
DBMS is Database Management System and RDBMS is Relational Database Management System. DBMS and RDBMS both are the procedures to store data in the form of columns and rows. The main difference between both is that in Relational Database Management System we can make a relationship between the tables. In RDBMS we also have an additional feature of putting constraints and ensuring security with regard to data manipulation. SQL Server is referred to as a server that implements Structured Query Language.
Following are the types of SQL Servers:
* SQL Server 2000
* SQL Server 2005
* SQL Server 2008
* SQL Server 2008 R2
SQL Server 2000: SQL Server 2000 is a relational database management system that offers a variety of administrative tools to ease the burdens of database development, maintenance and administration. It was introduced in 2000 and the code name for this is "Shiloh". In 2003 SQL Server 2000 64-bit Edition was introduced and its code name is "Liberty".
SQL Server 2005: SQL Server 2005 was released in October 2005. It is the advance version of SQL Server 2000. Its code name is "Yukon".
Features of SQL 2005 are:
* Multiple Active Results Sets - This feature allows usage of database connection for multiple purposes. Also known as "MARS".
* Provide support for managing XML (Extensible Markup Language) data, in addition to relational data.
* Database Mirroring - This is the technique of copying data from one location to another (storage device) in real time. With the help of data mirroring we can easily recover critical data.
SQL Server 2008: SQL Server 2008 was released in 2008 and the code name for this is "Katmai". SQL Server 2008 comes up with new features for data management these features were:
SQL Server 2008 R2: SQL Server 2008 R2 is the latest available version. The code name for this is "Kilimanjaro (aka KJ)".
Features of SQL Server 2008 R2 are:
* Master data management system or Master Data Services
* Multi Server Management