Try our new research platform with insights from 80,000+ expert users

SQL Server vs Vertica comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

SQL Server
Average Rating
8.4
Reviews Sentiment
6.8
Number of Reviews
268
Ranking in other categories
Relational Databases Tools (1st)
Vertica
Average Rating
8.2
Reviews Sentiment
7.0
Number of Reviews
86
Ranking in other categories
Data Warehouse (5th), Cloud Data Warehouse (11th)
 

Mindshare comparison

SQL Server and Vertica aren’t in the same category and serve different purposes. SQL Server is designed for Relational Databases Tools and holds a mindshare of 18.6%, down 23.1% compared to last year.
Vertica, on the other hand, focuses on Data Warehouse, holds 8.6% mindshare, down 8.7% since last year.
Relational Databases Tools
Data Warehouse
 

Featured Reviews

Azizul Haque - PeerSpot reviewer
It has eliminated all kinds of inconsistencies, and it is reliable, secure, and fast
I don't know whether SQL Server can support large organizations where the database size is more than 100 GB. It might be because of SQL Server, or it might be because of the programming of the software vendor, but a lot of people think that it is a problem with SQL Server. It can't handle a large amount of data or large data size. In terms of its usage, about 90% of our applications are running on the SQL Server database. We have around 1,600 users for our software, and all the applications are connected to the SQL Server database.
T Venkatesh - PeerSpot reviewer
Processes query faster through multiple systems simultaneously, but it could support different data types
We use the solution for various tasks, including preparing data marts and generating offers. It helps extract data based on rules from the policy team and provides insights to enhance business operations. We also analyze transactions to target customers and improve business performance The…

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"The solution is very easy to use. It's intuitive and easy to navigate. Overall, it's a straightforward product."
"There is no lack of features."
"Comparing with other database management systems that I tried in other companies, SQL Server is quite easy to install, configure, and maintain."
"It's great that the database engine is always on."
"The columnstore index feature is useful for us, and we also use the integration services. It is also very stable."
"The solution is very common. It's easy to use."
"The most valuable feature is that it is easy to use and you don't have to do a lot of configuration."
"The most valuable feature of SQL Server is that it is easy to set up."
"The extensibility and efficiency provided by their C++ SDK."
"The solution was executed quite quickly due to its columnar storage underground, which is the most valuable feature of our company"
"Speed and resiliency are probably the best parts of this product."
"Vertica gives knowledgeable users and DBAs excellent tools for tuning."
"It has improved my organization's functionality and performance."
"The solution is quick, has good compression data, and is not expensive."
"I enjoy the cybersecurity and backup features."
"The solution has great capabilities. The tool that instructs the internal database forward is easy to use and is very powerful."
 

Cons

"They could improve the solution by allowing more portability between on-premise and the cloud."
"Although I am satisfied with the solution, some clients have asked us to resolve technical issues, such as those involving silver solution and replication."
"The solution could offer more integration with other platforms."
"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."
"The pricing of the product could be better."
"The remote access aspect needs to be improved in terms of security."
"The security features of the solution could be better."
"The solution could improve by having more integration with other operating systems and other platforms."
"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."
"Whatever's out, the core is not always as great as the engine, especially their first version."
"Performance of management of metadata layer (database catalog) needs improvement. We still have to have smaller customers on PostgreSQL; Vertica cannot manage thousands of schemata."
"Fact-to-fact joins on multi-billion record tables perform poorly."
"The biggest problem is the cost of cloud deployment."
"I have found that coding support could be simplified."
"In my opinion, Vertica's documentation could be improved. Currently, there is not enough documentation available to gain a comprehensive understanding of the platform."
"It would be great if this were a managed service in AWS."
 

Pricing and Cost Advice

"The product is expensive."
"The price could be cheaper."
"The licenses are really expensive. Their licensing model should be more simplistic."
"Pricing for this product is very reasonable."
"Some of our clients purchase the license and others do not, they use Express SQL Server."
"Pricing is a bit on the higher side."
"Currently, almost all of my machines are in Azure and I think it is the best way of licensing now (VM+software)."
"We did a one-time payment. Its price, in general, can be reduced."
"I think it's starting to get a little expensive. Open source products are starting to get more robust, so I think that's something that they need to start looking at in terms of licensing."
"The price is reasonable. We use a pay per license model. Firstly, you need to buy a license. After that, you mainly pay the annual support fee of around 20% or 25%. I think their prices are quite reasonable."
"The pricing and licensing depend on the size of your environment and the zone where you want to implement."
"From a cost perspective, the software is less than most of its competitors."
"I am aware that we have licensed it, but I have no knowledge of its cost."
"The pricing could improve, it is a little expensive."
"Read the fine print carefully."
"It's difficult today to compete with open-source solutions. In these areas, there is a lot of competition and the price of this solution is a bit pricy."
report
Use our free recommendation engine to learn which Relational Databases Tools solutions are best for your needs.
848,716 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Educational Organization
50%
Financial Services Firm
8%
Computer Software Company
7%
Manufacturing Company
5%
Financial Services Firm
19%
Computer Software Company
18%
Manufacturing Company
7%
Real Estate/Law Firm
4%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

Would you say the price of SQL Server is high compared to that of similar products?
SQL Server is fairly priced because it has various editions, depending on the number of users, servers, or core packs you are using. If you compare the product to others in this category, the price...
Has using SQL Server helped your organization in any way?
SQL Server has helped my organization through partitioning to distribute the workload, as it splits them up into smaller pieces so the machines can easily deal with it. However, this comes with a h...
Which authentication mode is best for SQL Server?
My company connects through SQL Server authentication. We have company Windows accounts, but we do not want to connect the two, out of security concerns and to keep things separated for our own pur...
What do you like most about Vertica?
Vertica is easy to use and provides really high performance, stability, and scalability.
What is your experience regarding pricing and costs for Vertica?
The solution is relatively cost-effective. Pricing and licensing are reasonable compared to other solutions.
What needs improvement with Vertica?
The product could improve by adding support for a wider variety of data types and enhancing features to better compete with other databases.
 

Comparisons

 

Also Known As

Microsoft SQL Server, MSSQL, MS SQL
Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand
 

Overview

 

Sample Customers

Microsoft SQL Server is used by businesses in every industry, including Great Western Bank, Aviva, the Volvo Car Corporation, BMW, Samsung, Principality Building Society, Wellmark Blue Cross and Blue Shield, and the Catholic District School Board of Eastern Ontario.
Cerner, Game Show Network Game, Guess by Marciano, Supercell, Etsy, Nascar, Empirix, adMarketplace, and Cardlytics.
Find out what your peers are saying about Microsoft, Oracle, SAP and others in Relational Databases Tools. Updated: March 2025.
848,716 professionals have used our research since 2012.