SQL Server Review

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


What is most valuable?

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

How has it helped 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.

What needs 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.

For how long have I used the solution?

I'm using this solution for 14 years.

What was my experience with deployment of the solution?

Deployment is pretty fluent.

What do I think about the stability of the solution?

No.

What do I think about the scalability of the solution?

Yes, mostly connected to bad code.

How are customer service and technical support?

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

Which solution did I use previously and why did I switch?

Better user experience, very rich functionality and good reliability.

How was the initial setup?

Pretty straightforward.

What about the implementation team?

In house.

What's my experience with pricing, setup cost, and licensing?

Impossible to say. We have about hundred SQL servers.

Which other solutions did I evaluate?

mySql, firebird, access, and probably some more.

What other advice do I have?

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.
More SQL Server reviews from users
...who work at a Computer Software Company
...who compared it with Oracle Database
Add a Comment
Guest
1 Comment

author avatarit_user2652 (Project Manager at a non-tech company with 10,001+ employees)
Top ReviewerVendor

How do you backup SQL server databases?