Microsoft SQL Server Reviews & Product Details

Not case sensitive, does calcution fast, scalable Review collected by and hosted on G2.com.

When altering table columns, one at a time Review collected by and hosted on G2.com.

I like the integration of the CRM. It is very user friendly as well. Review collected by and hosted on G2.com.

Nothing. I think Microsoft SQL exceeds the customer expectation. Review collected by and hosted on G2.com.

Easy format to learn if you have some basic knowledge of different types of code and lots of resources to find answers to problems. Review collected by and hosted on G2.com.

Some additional knowledge is required as to how data gets joined and aggregated. If done incorrectly may cause incorrect data to be reported Review collected by and hosted on G2.com.

Microsoft SQL is a standard for applying the Structured Query Language to tabular databases, which makes life much easier when your database is massive. You can select the data that you want using clear syntax, and from there work more quickly. Review collected by and hosted on G2.com.

I dislike that Microsoft SQL isn't as as streamlined as you might expect. For example, it takes many more keystrokes and clicks to import a table than it should, and table entries that are too large may not display properly. Review collected by and hosted on G2.com.

Reports and queries are fast ready when mangement makes a request for reports. Review collected by and hosted on G2.com.

Queries need to be individually customized to specific reports. Review collected by and hosted on G2.com.

Easy to use .

Faster access of data .

Security .

New T-SQL functions in MS sQL .

Temporal tables functionality in 2016 . Review collected by and hosted on G2.com.

Not easy to set up roles and permissions .

Replication doesn’t work most of the times Review collected by and hosted on G2.com.

Its implementation often meets the budget and resources and queries can be optimized to provide huge increase in performance. With a great amount of online community support, simple deployment process and integration with microsoft msbi suite, this is one of the best platforms! Review collected by and hosted on G2.com.

Its not the best when it comes to ease of use and debugging of errors. Learning the syntax could be one downside and another is having to schedule backups rather than do continuous archiving. Review collected by and hosted on G2.com.

Polybase system and the ease to interact with hadoop big data clusters. Review collected by and hosted on G2.com.

external sql manager. this should be built in sql studio manager since it controls crucial settings Review collected by and hosted on G2.com.

MSSQL is very reliable.

The features of easy scripting, Reporting Services for uploading reports of your products are very useful. You can actually view the reports if you donot have the dedicated report viewer in your product. Review collected by and hosted on G2.com.

The process take lot of memory which degrades the machine performance. Review collected by and hosted on G2.com.

Graphical user interface is very simple and reliable. Review collected by and hosted on G2.com.

Crashing problems if sql execution plan is too lengthy. Review collected by and hosted on G2.com.