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."The solution can be deployed in a few minutes."
"It's great that the nodes are synchronized so if you lose one it automatically moves to another."
"I like that it's relatively stable."
"Its usability is very good. Its performance is satisfactory."
"The solution is easy to use."
"I have found the whole solution with all its features wonderful."
"The installation is really easy."
"We have found the solution valuable because we are able to easily create a query, shrink, backup, and make new tables."
"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."
"I have found the solution to be scalable."
"Vertica is a columnar database where the query performance is extremely fast and it can be used for real-time integrations for API and other applications. The solution requires zero maintenance which is helpful."
"I like the projection feature, which increases query performance."
"Its projections and encoding are excellent tools for tuning large volumes."
"Its analytics has enabled Pythian's clients to get the business insights as quick as they wanted. Its lower maintenance has also improved the ROI."
"The most valuable feature of Vertica is the unmatchable database performance."
"It has improved my organization's functionality and performance."
"I would like to see more integration with other platforms."
"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."
"The solution is lacking a compound index for comparing values."
"The performance is not always the best."
"Linux-based editions are not yet proven to be on par with Windows deployments."
"The performance degrades when the data is huge."
"The pricing and quality of the product could be improved."
"In terms of what could be improved, everything on-premise is now moving to the cloud. Obviously SQL Server has also moved, because Microsoft Excel has its own cloud called Azure Finance. Every solution comes with its own advantages and disadvantages."
"In my opinion, Vertica's documentation could be improved. Currently, there is not enough documentation available to gain a comprehensive understanding of the platform."
"They could improve the integration and some of the features in the cloud version."
"We faced some challenges when trying to use the temporary tables feature."
"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."
"Suboptimal projection design causes queries to not scale linearly."
"Vertica seems to scale well, except for one use case where you are on a multi-node cluster. For example, if you had a nine-node cluster, one node goes down, then the eight nodes don't scale, because the absence of the node is very apparent, which is a problem. If you have nine nodes or multiple nodes, the whole idea is that if one of those nodes goes down, then you should not see an impact on the system if you have enough capacity. Even though we have enough capacity, you can still see the impact of the one node going down."
"The integration of this solution with ODI could be improved."
"Fact-to-fact joins on multi-billion record tables perform poorly."
SQL Server is ranked 1st in Relational Databases Tools with 259 reviews while Vertica is ranked 4th in Data Warehouse with 82 reviews. SQL Server is rated 8.4, while Vertica is rated 8.4. 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.