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?
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?
What about the implementation team?
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.
Jun 27 2014