SQL Server is a "Relational Database Management System" product processed by Microsoft. It has been built up for the basic function of storing  and recovering information as required by different applications. It can be executed on the same system or on the different system. The Microsoft SQL Server is a powerful and reliable open source data management system that delivers a rich and reliable data for storing the applications on the desktop and Web Sites. SQL Server supports the basic and standard language of database technology i.e,"Structured Query Language".It is a database base product build by IBM,which is a case insensitive language and common for all database technologies.

• Microsoft SQL Server - Is a relational database management system developed by Microsoft.

Microsoft SQL Server consists of some of the key applications that provides some of the pictorial sessions such as: Scalability issues contains some of the common design and configuration issues cause most scalability problems.

Postponing the scaling decision

By postponing the scaling decisions are of many things that one can work it out for improving the performance.

Application architecture and design issues

Application level changes can be the most effective if one have the option of architectural designing.

Database architecture and design issues

Database level designing changes can have a huge impact on the performance on database architecture.

Indexing strategy and maintenance

Indexing strategy and maintenance contains the correct indexes that is placed that are extremely important. And the DBA is more likely to have control over the indexing strategy.And all the feature that contain in the index maintenance are necessary needed.

• SQL Server - Is a relational database management system product processed by Microsoft.
• Supports - SQL Server supports the standard database language SQL.