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 is valuable because it seamlessly extracts reports and enables the collection of information from different tables."
"The solution is very easy to use."
"It's a good option for those that have a lot of Microsoft solutions in use."
"It is fairly easy to work with. I like the high-availability options, like mirroring for example, and the high-availability groups."
"It is easy to use and very stable."
"A big advantage is the ability to store any type of data in SQL Server."
"I like that the new version has a memory-optimized table to improve the performance."
"The solution is configurable."
"Vertica is a columnar database, this support our developments in analytics, advanced analytics, and ETL process with large sets of data."
"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."
"Integrated R and geospatial functions are helping us improve efficiency and explore new revenue streams. "
"Vertica's most outstanding features are the compression rates achieved and the speed of access of high volume data."
"Eighty percent of the ETL operations have improved since implementing this solution."
"The hardware usage and speed has been the most valuable feature of this solution. It is very fast and has saved us a lot of money."
"The most valuable feature is Vertica's performance and the ease of using the database."
"It has improved my organization's functionality and performance."
"Its ability to handle certain kinds of large data could be improved."
"They can build more performance-tuning tools in it. They can also make the stuff a little more user-friendly and provide the ability to schedule jobs. They can perhaps also streamline it a little bit so that it is not so resource-intensive, which would be helpful. SQL Server has a tendency to consume all the memory you allow it to. If you are not careful, you can basically break your server. I would like to see it having a smaller footprint in terms of system resource consumption. They might want to consider re-evaluating their pricing. It is expensive."
"I would like to see native plugins built for other platforms versus having to buy third-party plugins to tap into S3 buckets and AWS Cloud. Right now, it does not have those built-in plugins."
"Their datatypes need improvement."
"The solution is lacking a compound index for comparing values."
"I would like to have the ability to restore backups in the next release."
"The integration could be better. They are not open-source, so the integration with other platforms is not that easy."
"The documentation could be much better. It's lacking right now. If there are better help pages, for even complicated queries and stuff like that that would be quite a help for users."
"It's hard to make it slow for a small data volume. For large volumes, it's hard to make it work. It's also hard to make it faster, and to make it scale."
"We faced some challenges when trying to use the temporary tables feature."
"Fact-to-fact joins on multi-billion record tables perform poorly."
"I would personally like to see extended developer tooling suited to Vertica – think published PowerDesigner SQL dialect support."
"Documentation has become much better, but can always use some improvement."
"They could improve the integration and some of the features in the cloud version."
"Support is an area where it could get better."
"There are a lot of limitations within this product and it makes things extremely hard for developers. It lacks Stored Procedure, packages, and triggers like other RDBMs."
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.