Microsoft SQL Server Reviews & Product Details

When it works it works great, easy to set up and the web/express editions, although limited are reasonable. More secure than other similar products. Review collected by and hosted on G2.com.

The pricing is a mess, different licenses and situations (clients/dev/Gold Partner) is just all confusing. The Enterprise edition is a joke of a price.

Any simple task never seems to work correctly, shrinking databases, scripts hardly ever work, even with Microsoft getting a remote session. Review collected by and hosted on G2.com.

Easy to use. Excellent management interface. Zero downtime back-ups. Reporting services are built into the application. Review collected by and hosted on G2.com.

Cost can get significant for corporations but perfect for education. Review collected by and hosted on G2.com.

Used by many applications with a high adoption rate. Integrates well with other products and, compared to other products, offers good value for the cost. Review collected by and hosted on G2.com.

CPU and RAM resource usage can be high at times. Would like to see core product improvements to add more value to customers. Reporting services could use some improvements to be more user friendly out of the box. Review collected by and hosted on G2.com.

I like most its inbuilt features as these are very helpful during the development - makes my task easy. Its very powerful tool for Relational Database Management System and compatible with cross platform as well as database connectivity on different application is preety smooth. Easy to communicate with linked servers i just need to define the configuration to perform this action. I can easily analyse the existing database objects.

I can review the performance of db objects just by using execution plan and statistics - when there is a serious issue in Stored Procedure performance then it provides the detail of misssing indexes in the execution plan. As well as to improve the performance easy to review such things using Database Tuning Adviser.

Its trace feature is awesome - i can easily capture the running SQL script(s) in the trace.

Monitoring dabase objects is so smooth.

Creation and modfication of Table, Function, Stored Procedure, View, Trigger, Index etc. so simple. Review collected by and hosted on G2.com.

Not much to dislike only the issue i noticed sometime it consumes CPU a bit high and requires a bit more space on disk for installation. Overall its meeting our requirement. Review collected by and hosted on G2.com.

Microsoft SQL server is a excellent database equipped with great components like SQL Profiler, Query Optimizer, Resource manager, SSIS , SSRS etc. Efficiency of MS sql server is very excellent in terms of read and updating the data. There is now support of migration to Azure Sql DB which makes it more portable in terms of cloud requirements. It also has ability to create a custom objects at permission and access granting level. creating auto SQL jobs is quiet easy and has a lot of features for quick use. Review collected by and hosted on G2.com.

Although very nice but i think it needs to be more scalable. SQL server is an excellent RDBMS only for mid size DB requirements. Review collected by and hosted on G2.com.

Perhaps the most straight forward of the database software and languages. I find the connection between other development tools and this tool to be the most smooth of all of the database providers. Review collected by and hosted on G2.com.

The UI of the SQL Server and SQL Server Management is lacking compared to newcomers to the game. It can be quite boring starting at Microsoft's database programs compared to competitors. Review collected by and hosted on G2.com.

Microsoft SQL Server is a great relational database management system. It runs well and does not take up a lot of storage. It is very user-friendly and can easily handle multiple databases. It is easy to write queries, view schemas, and analyze data. Review collected by and hosted on G2.com.

The errors are not very helpful. They don't usually tell you what is wrong or how to fix your query. Review collected by and hosted on G2.com.

Provides English like queries to manipulate data.

Provides intelligence help to users to write queries.

Helps users with many built-in functions and procedures to manipulate data.

User can also create own functions and Procedures.

Helps to store and manipulate data. Review collected by and hosted on G2.com.

Installation takes more time.

User sometimes need to refresh local cache to take help of intelligence.

Takes large memory after installation so hangs some times while working with large quires. Review collected by and hosted on G2.com.

SQL server is most of best and most reliable relational database management system with lots of features like user defined procedures, functions, query optimisation, indexes , Merge, CTE, jobs execution, SSIS , SSAS, dynamic memory management and it's excellent compatibility with web based technologies . Integration is very easy and interface is self explanatory. Microsoft support and user community for SQL is excellent. Review collected by and hosted on G2.com.

Only one issue Microsoft license fees is quite high with an increase every year. Rest of your organisation can afford this then there's nothing best in market till date. Review collected by and hosted on G2.com.

This is hands down the best client for SQL is out there, not only is it graphically more comprehensible but it's also capable of connecting with Microsoft Excel which will make your life easier. Review collected by and hosted on G2.com.

If you are to build a database from a scratch it could be confusing if it's your first time. Review collected by and hosted on G2.com.