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 columnstore index feature is useful for us, and we also use the integration services. It is also very stable."
"This solution has proven stability and operational power."
"SQL Server Profiler makes finding and debugging easy."
"SQL Server is quite stable. And now we are using the Lattice 2017 version."
"SQL Server is widely used and it's simple. You cannot do without Microsoft if you want to manage IT for a business customer."
"SQL Server is a very mature solution."
"The documentation and manuals are very good."
"Without any doubt the Integration Services and Analysis Services are the most widely used. These are the basis for data quality, data gathering, ETL process, as well as collation for the data warehouse, Cube-generation, and ad-hoc processes. The ease in which you may mold a process flow or even modularly add in new structures is something which is much needed in my job."
"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."
"The solution is quick, has good compression data, and is not expensive."
"For me, It's performance, scalability, low cost, and it's integrated into enterprise and big data environments."
"It has improved my organization's functionality and performance."
"The solution has great capabilities. The tool that instructs the internal database forward is easy to use and is very powerful."
"The most valuable feature of Vertica is the unmatchable database performance."
"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."
"The maintenance and tasks should be improved so as to reduce database files."
"Performance could be improved. There could be more support to PHP-based websites and to providing direct plugins for connections, and the related services or application services could be improved."
"The pricing could be more affordable."
"Performance could be improved."
"They could improve by adding the SQL format."
"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."
"SQL Server could improve by being more user-friendly, it is still geared towards specialists. Additionally, the monitoring system is difficult to use, not everyone can use it well. The configuration should be able to be done through the GUI."
"If SQL Server could perhaps run on Linux, that would be good. Most of us prefer Linux and I've used a lot of Linux. I understand that SQL Server is quite powerful, but I'm not sure if the functionality is there, but if it could be used in an open-source type of environment, it would be very good."
"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."
"It should provide a GUI interface for data management and tuning."
"Limitations in group by projections is where I would like to see an improvement."
"They could improve on customer service."
"I think they need an easy client so that you can write queries easily, but it's not necessarily a weak point. I think some users would need them."
"We faced some challenges when trying to use the temporary tables feature."
"Vertica's native cloud support could be improved, and its installation could be made easier."
"In my opinion, Vertica's documentation could be improved. Currently, there is not enough documentation available to gain a comprehensive understanding of the platform."
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.