SQL Server Review

SQL server is probably one of the best relational database servers.

Valuable Features

Indexes, CTE, aggregate functions, partitions, memory optimized tables, service broker, CLR (C# assemblies),...

Improvements to My Organization

Can't imagine work without sql database. I have complete warehouse logic inside stored procedure and it works like a charm. It is installed in 20 companies with different warehouse types.

Room for Improvement

There is always some place for improvements. Statistics could be better (2 table statistic), or dynamic partition function, but that is probably true with every other product.

Use of Solution

I'm using this solution for 14 years.

Deployment Issues

Deployment is pretty fluent.

Stability Issues


Scalability Issues

Yes, mostly connected to bad code.

Customer Service and Technical Support

Customer Service: Very good.Technical Support: Very good.

Previous Solutions

Better user experience, very rich functionality and good reliability.

Initial Setup

Pretty straightforward.

Implementation Team

In house.

Pricing, Setup Cost and Licensing

Impossible to say. We have about hundred SQL servers.

Other Solutions Considered

mySql, firebird, access, and probably some more.

Other Advice

With right use it could be part of almost any size and type of company.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
1 visitor found this review helpful
1 Comment
Project Manager at a non-tech company with 10,001+ employeesConsultantTOP REVIEWER

How do you backup SQL server databases?

26 October 14
Sign Up with Email