Microsoft SQL Server Reviews & Product Details

Auto fill feature makes it easy to run queries. Relatively intuitive program. Review collected by and hosted on G2.com.

Not easy to troubleshoot issues. Could use a better help guide. Review collected by and hosted on G2.com.

really cool features in SQL Server 2014 -

Power BI for office 365 integration

Storage improvements like IO Control

Buffer Pool extension (Don't think other RDBMS offer this yet)

Always on improvements

In-Memory OLTP Engine for high speed transactions

Improvements in BI Review collected by and hosted on G2.com.

Less documentation on some of the new features on the product page. Review collected by and hosted on G2.com.

I like all of the tools that SQL Server and the corresponding SQL Server Management Studio utilize. In particular, the management studio makes browsing my databases easy, and has nice tools that optimize tasks such as generating scripts for building stored procedures. The design table functionality through the GUI is easy to use for a seasoned developer. Review collected by and hosted on G2.com.

I honestly don't have many gripes about MS-SQL. The tools are easy to use, and the performance is solid. Review collected by and hosted on G2.com.

Microsoft SQL Server is a Relational Database Management System (RDBMS), that I have been using for about 4 years now. As I was a beginner with the MSSQL Server, I found it the easiest and quickest to learn with it's decent Graphical User Interface (GUI) increasing the ease-of use. It is my to-go tool when on the Windows platform as it provides a reliable and high-performance output. I like the MS SQL server (as it is called) since it compresses the data, while saving the index to a disk, resulting in better performance due to a smaller in-memory footprint. Another thing that I like about the SQL Server is that it uses SYBASE storage engine, which is ACID compliant for reliability. Report generation capacities with the native Microsoft Access support is a good plus too! Pretty recently, the SQL Server 2016 was also released. I am yet to try it out. Review collected by and hosted on G2.com.

I faced quiet a few problems with the MS SQL server installation. For example, it disliked that Data Execution Prevention (DEP) was turned on. The installation even had a problem with the Internet Explorer Enhanced Security! Also, after a certain size limit, the the SQL Server tends to be a memory hog. So, I have learned to monitor the counters that indicate most common causes for processor pressure, such as 'Batch Requests/sec,' 'SQL Compilations/sec,' and 'SQL Recompilations/sec'. These counters are available in Performance Monitor under the sys.dm_os_performance_counters view. Review collected by and hosted on G2.com.

Microsoft SQL server comes with much higher version of SQL for development purposes Review collected by and hosted on G2.com.

Sometimes other new version changes comes with lot glitches and this Microsoft SQL server only work on window platform. Review collected by and hosted on G2.com.

SQL server can connect perfectly for my .net applications and easy to use Review collected by and hosted on G2.com.

difficult to move database between different version of SQL Server Review collected by and hosted on G2.com.

Helpful for using SQL server at our university. Review collected by and hosted on G2.com.

Sometimes freezes and not very user friendly. Review collected by and hosted on G2.com.

Easy and quick data extraction, graphical table creation and query design. Review collected by and hosted on G2.com.

Rigid result view, only textual view. Needs visualization. Review collected by and hosted on G2.com.

The performance is great and provides connectivity to large number of sources. It integrates with Data quality services and SASS software. One of the best part feature is that it provides plugins to support and interface with salesforce application. It also includes a SQL server agent which comes in very handy. Review collected by and hosted on G2.com.

At times it uses a lot of resources and there is no memory usage provided. Also, it is not consistent with data types and they are not always correct when reading from views. Review collected by and hosted on G2.com.

Stable product that is the base of our enterprise software solution. Runs good with out a whole lot of maintenance and is much more user friendly than it used to be. Review collected by and hosted on G2.com.

I need to take a SQL Class to learn the correct syntax to make a better use of the software. Review collected by and hosted on G2.com.