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."SQL Server is a highly stable solution."
"It's a good option for those that have a lot of Microsoft solutions in use."
"The main feature of this solution is ease of use."
"The most valuable feature of the solution, compared to other RDBMS solutions, such as Oracle MySQL or IBM DB2, it is more user-friendly and has backward compatibility. For example, if you have an application that requires an old version of SQL Server and you have the latest version of the license, you are able to install and use it in backward compatibility mode. They keep supporting the existing legacy application."
"The scalability of the product is great."
"SQL Server is essentially the backbone of every microservice. From a developer's perspective, it is the backbone of all microservices. The tool enables data retrieval, set data, and essential operations, ensuring the smooth functioning of applications. In essence, it is the integral part that keeps applications operational."
"The interface is user friendly."
"The ease of administration, in general, is the solution's most valuable aspect."
"Initiate on one node, and the RPM propagates automatically to all other nodes. "
"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 feature of the product that is most important is the speed. I needed a columnar database, and its speed is what it's built to do, and so that's what really does differentiate Vertica from its competitors."
"Any novice user can tune vertical queries with minimal training (or no training at all)."
"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."
"The most valuable feature is Vertica's performance and the ease of using the database."
"Allows us to take volumes and process them at a very high speed."
"The extensibility and efficiency provided by their C++ SDK."
"In my experience, I've found that scalability can be improved."
"Query optimitzer could be simplified."
"When we run into problems, it's usually during installation, and finding answers to the problem has been a nightmare because the documentation is terrible."
"Scalability of the database could be improved if it could handle increased volumes of data."
"Only one CPU core can be used. Can’t move a database between servers easily. Can’t use triggers."
"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."
"The solution could improve by having better integration."
"While using it, we really didn't experience any pain points."
"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."
"Whatever's out, the core is not always as great as the engine, especially their first version."
"Monitoring tools need to be lightweight. They should not take up heavy resources of the main server."
"They could improve on customer service."
"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."
"I believe the installation process could be streamlined."
"Vertica can improve automation and documentation. Additionally, the solution can be simplified."
"Fact-to-fact joins on multi-billion record tables perform poorly."
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.