Microsoft SQL Server Reviews & Product Details

Undoubtedly, the tree structure that includes multiple servers/ database that provides ease of access. Super easy to work with SQL. Review collected by and hosted on G2.com.

Should have connectivity to non sql databases. Difficult to get data from different sources of database at one place. Review collected by and hosted on G2.com.

Microsoft SQL Server provides robust database features to support enterprise needs. It runs on a widely known operating system. It scales as your needs increase. It provides redundancy and high availability features. Review collected by and hosted on G2.com.

Pricing can be difficult for medium sized companies. There is a breaking point between client access licenses and per processor/core licenses that needs to be observed in order to get the best bang for your buck. Review collected by and hosted on G2.com.

The speed at which SQL load is awesome. Especially the BCP tool Review collected by and hosted on G2.com.

The fetch from SQK us extremely painful. Review collected by and hosted on G2.com.

The simplicity of the language makes it easier to understand and implement statements like joins or procedures in high-level programming language. Hence, it appeals more to beginners as well.

Using other add-ins can greatly extend the features of SQL and make the work easier for the users. This helps in just SQL SSMS as well as for SSRS or other branches of SQL. I would really prefer using Microsoft SQL for performance tuning using Indexing as well for increasing the speed and efficiency in obtaining results. Review collected by and hosted on G2.com.

Sometimes, if not handled properly with a predefined schema, relations and maintenance of data becomes an issue. This mainly happens only when it comes to new users or with people who aren't working as a part of a bigger man-force handling the system.

Certain add-ins give useful features as well, but if SQL were to add these themselves it would save the users the trouble of finding and installing them. Review collected by and hosted on G2.com.

Excellent relational database with extensive SQL query support.

Depending on the need there are different flavors of SQL to choose, like SQL Express, Developer, Standard, Enterprise etc. Express and Developer edition is specially quite useful if you want to try out the product and/or doing development.

SQL database can hold a large amount of data and SQL server can efficiently structure the query.

SQL server management studio is quite useful for debugging purpose. SQL profiler can be used for optimising the SQL queries.

Its highly secure database and DB admin can control who has access to the databases. There are different access levels also.

It has excellent integration with Microsoft technologies like .Net framework, LINQ queries, Visual Studio, Web application etc. Review collected by and hosted on G2.com.

SQL server consume lots of memory and needs a high performing multi-core machine especially if the database size is big. Inefficient SQL queries can impact the performance of SQL. Unnecessary locks on SQL operations can also impact its performance.

If your DB size grow (>20GB) then its performance is not up to the mark.

MS SQL is not a good choice if you DB size is huge (like in tera bytes). Review collected by and hosted on G2.com.

The syntax is very easy and easy to learn Review collected by and hosted on G2.com.

Sometimes the performance is not good and it can be optimised Review collected by and hosted on G2.com.

Ease of use. Works with windows. Installation was a breeze Review collected by and hosted on G2.com.

Nothing to dislike. Maybe speed factor. Review collected by and hosted on G2.com.

flexibility software - when dealing with integrated solutions, with innovation and easy to use applications. Review collected by and hosted on G2.com.

not too much to not like. I like to learn more about the product. I am interested in any free online training. Review collected by and hosted on G2.com.

It's very stable with our SharePoint environment. Even when doing patching on a fail over system we haven't had issues. Review collected by and hosted on G2.com.

Some times the configuration of the log files get a little cluttered since it won't grow in size on its own. Space needs to be allocated before hand. Review collected by and hosted on G2.com.

It's a Standard in industry like Oracle. Robust in data management and powerfull office integration. You can use it for every app you want to manage data. Review collected by and hosted on G2.com.

The price for very large servers is expensive. You need to purchase special licenses for each CPU even if the system is virtualized. Review collected by and hosted on G2.com.