Compare SQL Server vs. Vertica

Cancel
You must select at least 2 products to compare!
SQL Server Logo
21,883 views|17,314 comparisons
Vertica Logo
12,463 views|7,530 comparisons
Most Helpful Review
Find out what your peers are saying about Microsoft, Oracle, SAP and others in Relational Databases. Updated: June 2021.
511,307 professionals have used our research since 2012.
Quotes From Members

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

Pros
"The most valuable feature is replication because we had several replicas of the SQL Server database in different geographical locations.""The availability is the most valuable feature. It has high availability. It also has good performance.""SQL is very easy to manage.""It helps with moving the design of the database into reality.""The feature that I have found most valuable is that it is easy to code.""Very good security features.""The features that we have found the most valuable are reliability, availability perspective, and current scalability.""The latest version supports for big data analytics. SQL Server's vector processing-based batch execution mode is now available to the entire execution of R or Python code. Since much of the work that tends to be done in R and Python involves aggregation, batch mode - which processes rows of data several at a time, can be very helpful."

More SQL Server Pros »

"Eighty percent of the ETL operations have improved since implementing this solution.""The performance is very good and the aggregate records are fast.""Vertica's most outstanding features are the compression rates achieved and the speed of access of high volume data.""Allows us to take volumes and process them at a very high speed.""For me, It's performance, scalability, low cost, and it's integrated into enterprise and big data environments.""Speed and resiliency are probably the best parts of this product.""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."

More Vertica Pros »

Cons
"I would like to have more replication scenarios.""In terms of improvement, it could use more integration with other products.""Occasionally the performance, as good as it is, is a bit off. We sometimes experience memory spiking. If they could maybe fix that aspect of the solution, that would be quite helpful for our organization.""The product overall would benefit from the addition of better tutorials to help master the skills necessary to actually build a project database. Right now, what is available isn't sufficient.""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.""Query optimitzer could be simplified.""The scalability and the high availability feature can be expanded or improved. Currently, there is a limitation on scalability. A feature similar to the Oracle Diagnostic feature can be included to provide a better user experience.""CAL licenses should cost less. Microsoft usually prices high for client access licenses. Server plus user client access license (CAL) licensing requires a separate Server license for each server on which the software is installed, plus a user CAL for each user accessing the server."

More SQL Server Cons »

"Fact-to-fact joins on multi-billion record tables perform poorly.""When it is about to reach the maximum storage capacity, it becomes slow.""Support is an area where it could get better.""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.""Some of our small to medium-sized customers would like to see containerization and flexibility from the deployment standpoint.""The geospatial functionality could be designed better.""We are looking for a cheaper deployment for the solution. Although we did a lot of benchmarks, like Redshift. We tried Redshift, it didn't work. It didn't work out for us as well.""They could improve on customer service."

More Vertica Cons »

Pricing and Cost Advice
"SQL Server is a cost-effective solution for a small database.""Pricing is reasonable for small organizations, but the scaling increases the price.""We didn't have any licensing costs for SQL Server.""We pay approximately $12,000 USD per month for both the server and the license.""The price could be cheaper.""Cost is a major derivative for any organization. It has a reasonable cost value, and its cloud support is also better than others. Comparatively, Oracle can do the same things or is even better in certain areas, but it is expensive. The cost along with the support are the plus factors for SQL Server.""We have had to purchase the Enterprise version to the tune of a few hundred thousand dollars, which is just ridiculous.""With recent releases, the Standard Edition (cheaper) SKU has some of the earlier version Enterprise features. SQL Express has some limitations."

More SQL Server Pricing and Cost Advice »

"From a cost perspective, the software is less than most of its competitors.""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.""The price could be cheaper and it is best to negotiate the price."

More Vertica Pricing and Cost Advice »

report
Use our free recommendation engine to learn which Relational Databases solutions are best for your needs.
511,307 professionals have used our research since 2012.
Questions from the Community
Top Answer: It's a good option for those that have a lot of Microsoft solutions in use.
Top Answer: Customers do have to pay to use the solution. They tend to pay on a yearly basis.
Top Answer: The solution needs to be more secure. It's lacking, compared to, for example, Oracle. The product needs to work on its scalability. Oracle can scale a bit more effectively. Sometimes we have some… more »
Top Answer: The solution has great capabilities. The tool that instructs the internal database forward is easy to use and is very powerful.
Top Answer: 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.
Top Answer: The product could be less expensive and could benefit from a better marketing strategy. In a future release, I would like to have one application to help create intelligent models.
Ranking
1st
Views
21,883
Comparisons
17,314
Reviews
71
Average Words per Review
478
Rating
8.2
4th
out of 30 in Data Warehouse
Views
12,463
Comparisons
7,530
Reviews
6
Average Words per Review
513
Rating
9.0
Popular Comparisons
Also Known As
Microsoft SQL Server, MSSQL, MS SQL
Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand
Learn More
Overview

SQL Server is the Microsoft-driven relational database management system. This system is used to store data as well as retrieve it when necessary; these functions can be supported by individual users or by multiple users within a larger network. The Microsoft SQL Server has warehousing options, quality and integration services, management tools that are simple to implement, as well as robust tools for development.

Looking at the more technical end of things, Microsoft SQL Server uses query languages such as T-SQL and ANSI SQL. Disaster recovery is one of the product's most prominent features, in addition to in-memory performance, scalability, and corporate business intelligence capabilities.

Micro Focus Vertica is the most advanced SQL database analytics portfolio built from the very first line of code to address the most demanding Big Data analytics initiatives. Micro Focus Vertica delivers speed without compromise, scale without limits, and the broadest range of consumption models. Choose Vertica on premise, on demand, in the cloud, or on Hadoop. With support for all leading BI and visualization tools, open source technologies like Hadoop and R, and built-in analytical functions, Vertica helps you derive more value from your Enterprise Data Warehouse and data lakes and get to market faster with your analytics initiatives.

To learn more about Micro Focus Vertica Advanced Analytics, visit our website.

Offer
Learn more about SQL Server
Learn more about Vertica
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.
Top Industries
REVIEWERS
Financial Services Firm17%
Computer Software Company13%
Manufacturing Company8%
Transportation Company6%
VISITORS READING REVIEWS
Computer Software Company26%
Comms Service Provider20%
Financial Services Firm7%
Media Company5%
REVIEWERS
Computer Software Company23%
Media Company19%
Marketing Services Firm16%
Comms Service Provider13%
VISITORS READING REVIEWS
Computer Software Company33%
Comms Service Provider18%
Financial Services Firm7%
Media Company6%
Company Size
REVIEWERS
Small Business41%
Midsize Enterprise22%
Large Enterprise38%
REVIEWERS
Small Business31%
Midsize Enterprise24%
Large Enterprise45%
Find out what your peers are saying about Microsoft, Oracle, SAP and others in Relational Databases. Updated: June 2021.
511,307 professionals have used our research since 2012.

SQL Server is ranked 1st in Relational Databases with 79 reviews while Vertica is ranked 4th in Data Warehouse with 8 reviews. SQL Server is rated 8.2, while Vertica is rated 9.0. The top reviewer of SQL Server writes "A stable, scalable, and easy-to-deploy solution that pretty much covers everything". On the other hand, the top reviewer of Vertica writes "Superior performance in speed and resilience makes this a very good warehousing solution". SQL Server is most compared with SAP HANA, Oracle Database, IBM Db2 Database, Teradata and CockroachDB, whereas Vertica is most compared with Snowflake, Amazon Redshift, Teradata, Apache Hadoop and Oracle Exadata.

See our list of .

We monitor all Relational Databases 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.