Microsoft SQL Server Reviews & Product Details

It is a standard for me, since year 2k ... and it has been progressing and if you're not planning on pro use for your company, you can still use a free (very complete) licence. Review collected by and hosted on G2.com.

The GUI has not been updated a lot. Can improve a little on this field. Review collected by and hosted on G2.com.

Enterprise level. Can handle anything that you can throw at it. Review collected by and hosted on G2.com.

This is only an enterprise level product. Not for small users. Review collected by and hosted on G2.com.

In my line of work I'm able to take multiple account numbers and enter the info into SQL and receive results that can easily be copied and pasted into an excel file and sent to UPS for the specific request. Review collected by and hosted on G2.com.

The Lear I got curve on this is huge and remains to be a challenge for me after 3 months of working it Review collected by and hosted on G2.com.

The main thing I like about Microsoft SQL is that it just works. The system is mature, familiar, and there are no surprises. Sometimes the simplest approach to a problem is to build a simple relational table structure as opposed to trying to force relational data into a NoSQL document model. Review collected by and hosted on G2.com.

There are few surprises when it comes to working with MS SQL. Many times a relational approach to data models can lead to large systems that are overly complicated when compared to their NoSQL counterparts. One weak point with MS SQL is it lags behind some of the more modern language features provided by PostgreSQL and also doesn't have the benefits of being open source. Unlike some of the more modern options it seems more difficult to take advantage of auto-scaling with MS SQL Review collected by and hosted on G2.com.

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.