Microsoft SQL Server Reviews & Product Details

I like best querying data from more than one table using the SQL, I like also the syntax checking and I like opening more than one tab for different queries a lot, also I like easy import and export structure or\and data between more than databases, I like also the object explorer as it list all servers, databases, views, SPs, tables, etc in one place, I like also script generation, it helps me a lot copy a big script with structure and data and execute it easily in another SQL server without backup and restore, also I like the accessing control. Review collected by and hosted on G2.com.

Not easy to setup and it hangs sometimes Review collected by and hosted on G2.com.

It’s awesome tool in the list of Microsoft stack. From easy of creating tables and queries for a database; to setting up a data warehouse; from reports to file tables to remote blobs; it’s just awesome and the list is long. Review collected by and hosted on G2.com.

There’s nothing not to like about this product other than the pricing which again can be justified with what it offers. Review collected by and hosted on G2.com.

I use this product from last 3 years and whenever need to check my data values , i use this product.

Easily find the column values from the table and also executed DDL, DML etc statements. Review collected by and hosted on G2.com.

It consumes lot of the memory in my system. Sometimes, results section get stuck in between, need to restart SQL product. Review collected by and hosted on G2.com.

SQL over the years has gotten much easier to use. The upgrades between versions have also gotten more simple. The overall database structure is reliable and has worked well. Review collected by and hosted on G2.com.

The worst part about sql lately is the licensing. You are required to license so much in the virtual environment and it makes it a budget concern, especially for a large company. Review collected by and hosted on G2.com.

New updates have streamlined the process Review collected by and hosted on G2.com.

still clunky and lacking user interface options Review collected by and hosted on G2.com.

If configured correctly with the proper hardware, SQL Server can be incredibly powerful, delivering millions of data points in the blink of an eye. Even poorly constructed schema can be arranged in views to allow developers to harness SQL's performance benefits. Review collected by and hosted on G2.com.

When developing queries with complicated schema, it can be helpful to visualize how the tables are arranged. While SQL Server Management Studio does supply a visual query designer, it can be frustrating to use as (1) it doesn't store your arrangement in memory and will reset if you re-open the designer and (2) can generate some really messy queries using some strange things like RIGHT joins. Review collected by and hosted on G2.com.

Window based sql services to stop and start the sql server process.

Sql profiler and Sql job Scheduler are very good features of Microsoft sql server.

Sql editor has nice support to validate queries, debug, execute queries, Check the performance plan of queries using query analyzer.

Writing queries is easy with intellisense support.

Bulk data delete and generating database scripts is really easy.

Plugin with other third party tools is easier.

Sql server has the inbuilt CLR support to execute C#/VB or any dll code. Review collected by and hosted on G2.com.

Database Restore and Restart process stuck when the database is in use. Sql server needs to restart to complete these tasks. Review collected by and hosted on G2.com.

The SSMS is user friendly and is really easy to use, there are many tutorials provided by Microsoft which makes it easy to use the product. Review collected by and hosted on G2.com.

Only the SQL express is free for students, if Microsoft can add few more features like reporting to the free package it will help students. Review collected by and hosted on G2.com.

Microsoft sql is very versatile and user friendly I found it is not ridiculously hard to learn how to access tables and understand how to edit them. Review collected by and hosted on G2.com.

Nothing really bad about it, as far as I’ve seen. Review collected by and hosted on G2.com.

The software is easy to use for a developer and database can be managed efficiently Review collected by and hosted on G2.com.

Slow running and hanging sometimes.Not always. Review collected by and hosted on G2.com.