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 is pretty fluent.
Yes, mostly connected to bad code.
Customer Service and Technical Support
Customer Service: Very good.Technical Support: Very good.
Better user experience, very rich functionality and good reliability.
Pricing, Setup Cost and Licensing
Impossible to say. We have about hundred SQL servers.
Other Solutions Considered
mySql, firebird, access, and probably some more.
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