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 easy to use, has rich feature sets, and is business-oriented."
"The availability is the most valuable feature. It has high availability. It also has good performance."
"The solution is very common. It's easy to use."
"Very easy to use, and it's very democratic in the enterprise."
"The solution is very easy to use."
"It is integrated with Microsoft tools."
"It's much more friendly in comparison with Oracle."
"We have many users, between 50 and 100 using the SQL Server product."
"It has improved my organization's functionality and performance."
"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."
"The most valuable feature is Vertica's performance and the ease of using the database."
"For me, It's performance, scalability, low cost, and it's integrated into enterprise and big data environments."
"I appreciate the flexibility offered by Vertica's projections. It allows for modifying the primary projection without altering the tables, which helps to optimize queries without the need to modify the underlying data."
"The most valuable feature of Vertica is the unmatchable database performance."
"Vertica gives knowledgeable users and DBAs excellent tools for tuning."
"The solution is quick, has good compression data, and is not expensive."
"The Management Studio is a pretty heavy piece of software, and it's sometimes slow. I would recommend making an express version of the Management Studio, which is lighter and has fewer features but is a little faster."
"I would like to see the performance improved. Migrating should be easier and the scalability needs improvement."
"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."
"Technical support could be better."
"I would like to see the integration with other platforms improved in the future."
"SQL Server could improve by increase the performance, it cannot handle large amounts of data. I did not find any additional features compared to others solutions."
"The pricing could be better."
"The performance needs some improvement and it needs more features integrated into it."
"It should provide a GUI interface for data management and tuning."
"Fact-to-fact joins on multi-billion record tables perform poorly."
"The documentation of Vertica is an area with shortcomings where improvements are required."
"The biggest problem is the cost of cloud deployment."
"The geospatial functionality could be designed better."
"Monitoring tools need to be lightweight. They should not take up heavy resources of the main server."
"In my opinion, Vertica's documentation could be improved. Currently, there is not enough documentation available to gain a comprehensive understanding of the platform."
"Vertica can improve automation and documentation. Additionally, the solution can be simplified."
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.