We performed a comparison between SQL Server and Vertica based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Oracle, SAP and others in Relational Databases Tools."Easy to implement and user-friendly relational database management system. This product is stable and scalable."
"The performance of SQL Server is perfect."
"It is a stable product, and it runs seamlessly. It is not complex."
"The product has very good online documentation that can be used for troubleshooting."
"The most valuable aspect is the ability to utilize jobs and various functions to accomplish specific tasks, which cannot be achieved with standard procedures alone. This allows for a combination of features and functionalities to be employed."
"I have found the whole solution with all its features wonderful."
"The most valuable aspect of the solution is that it's integrated with the Visual Studio and also with Microsoft SQL Server Management Studio. It's a tool they have and it's quite easy to use and understand. It's the interface for programming for SQL Services."
"The backup capabilities are extremely good."
"It maximize cloud economics for mission-critical big data analytical initiatives."
"Integrated R and geospatial functions are helping us improve efficiency and explore new revenue streams. "
"The most valuable feature of Vertica is the ability to receive large aggregations at a very quick pace. The use case of subclusters is very good."
"It's the fastest database I have ever tested. That's the most important feature of Vertica."
"I enjoy the cybersecurity and backup features."
"The feature I like best is performance. We use Red Tool and Red Job for the data warehouse and reporting. It's perfect. Performance is good, and it can return ad hoc queries very quickly. Of course, it's a cluster, so it's easy to scale."
"Vertica is a great product because customers can compress and code data. The infrastructure that data warehouse solutions need is a commodity server so that customers don't have to invest in infrastructure."
"Initiate on one node, and the RPM propagates automatically to all other nodes. "
"The web interface and the command line interface could be better so we could manage and build some things around an API. If we could build our own solution, our own interface, and then manage the solution through that open API, that would be better."
"Maintenance of the solution is an area of concern, and improvements can be helpful."
"Their datatypes need improvement."
"The performance could improve."
"We experience latency at times when there is a lot of data being processed."
"I would say that people should know how to get a SQL setup in place since it might be an area where they lack when it comes to the solution."
"The product overall would benefit from the addition of better tutorials to help master the skills necessary to actually build a project database. Right now, what is available isn't sufficient."
"The stored procedure integration with our development could be better. Things are always changing very fast at Microsoft, and it takes a lot of resources to get on top of it. We're struggling with version control. In terms of new features, we don't have any feature requests. We are not focusing on the database."
"Documentation has become much better, but can always use some improvement."
"The integration of this solution with ODI could be improved."
"I have found that coding support could be simplified."
"Monitoring tools need to be lightweight. They should not take up heavy resources of the main server."
"Promotion/marketing must be improved, even though it is a very useful product at very good price, it is not as "popular" as it should be."
"Support is an area where it could get better."
"Suboptimal projection design causes queries to not scale linearly."
"They could improve on customer service."
SQL Server is ranked 1st in Relational Databases Tools with 260 reviews while Vertica is ranked 4th in Data Warehouse with 83 reviews. SQL Server is rated 8.4, while Vertica is rated 8.2. The top reviewer of SQL Server writes "Easy to use and provides good speed and data recovery". On the other hand, the top reviewer of Vertica writes " A user-friendly tool that needs to improve its documentation part". SQL Server is most compared with MariaDB, SAP HANA, Oracle Database, LocalDB and IBM Informix, whereas Vertica is most compared with Snowflake, Amazon Redshift, Teradata, Oracle Exadata and BigQuery.
We monitor all Relational Databases Tools reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.