Microsoft SQL Server Reviews & Product Details

What I like best in MS SQL, like any other Microsoft product, is the simple and easy to use user-interface (I guess most of us are familiar with Windows). I can make queries and scripts easily and without any trouble. Basic SQL knowledge is required.

What I love most about MS SQL is the Profiler. It's very handy and it helped me a lot when debugging apps. It allows you to see what's "happening" on the server, what scripts are executed, along with the parameters, which does not seem to be supported by other RDBMS.. Review collected by and hosted on G2.com.

It sometimes lags. It doesn't paginate result sets which could be problematic when searching millions of record. It needs more RAM utilization and conservation. Review collected by and hosted on G2.com.

Easy to understand for someone with even a basic understanding of relationship database architecture, queries, views, and stored procedures. Review collected by and hosted on G2.com.

I wish I had a better way to help less-experienced users write proper syntax. I.e. suggestions if there is incorrect syntax. Review collected by and hosted on G2.com.

It has a strong support from Microsoft and also by the community. It is also widely adopted by different industries. Review collected by and hosted on G2.com.

Microsoft does not seem to add any relevant features in the new versions of SQL Server. Review collected by and hosted on G2.com.

Microsoft SQL is good, gets the job done as what database servers should be. Review collected by and hosted on G2.com.

Microsoft SQL Server..... it only runs in Windows Environment

Running Windows in a server eats up a lot of server resources and needless to say the LICENSE.

It will be very very hard for small businesses to invest in MSSQL due to pricing Review collected by and hosted on G2.com.

Reports and questions to dig down data in fraction of seconds Review collected by and hosted on G2.com.

It’s fragile structure which is hard to make changes Review collected by and hosted on G2.com.

Hirerachy, data masking, data integration, etc. Review collected by and hosted on G2.com.

There is nothing that I don't like. So for now everything is so good Review collected by and hosted on G2.com.

Its simple windows based and easy to setup and run for simple setup. you can backup and recover using GUI. New versions are getting better and they now support linux with a rpm based install.

If you start using complex set up then you must make sure you have a good in-house DBA Team. Review collected by and hosted on G2.com.

Access management is not very tightly defined and GUI can be very confusing Review collected by and hosted on G2.com.

It’s a great way to manAge and organize data. Review collected by and hosted on G2.com.

It can be very slow at times. Microsoft needs Review collected by and hosted on G2.com.

MS SQL is now very powerful database server and getting better with new version Review collected by and hosted on G2.com.

Pricing point it can be cheaper. For always on realtime sync has latency and it must be fixed in next versions to use this db as full sync redundant db. Review collected by and hosted on G2.com.

When the server response time is good, the tools available in SSAS are quite useful. Review collected by and hosted on G2.com.

Bad server response time out errors are quite frustrating. Review collected by and hosted on G2.com.