SQL Server vs Vertica

SQL Server is ranked 4th in Relational Databases with 24 reviews vs Vertica which is ranked 2nd in Data Warehouse with 52 reviews. The top reviewer of SQL Server writes "Just like a Windows PC needs basic defragmentation maintenance to run effectively, SQL Server needs its own regular maintenance". The top reviewer of Vertica writes "The ability to view running queries and cancel problem ones from the Management Console is a very nice feature". SQL Server is most compared with Teradata, SAP IQ and Oracle Database. Vertica is most compared with Oracle Exadata, Teradata and Pivotal Greenplum.
Cancel
You must select at least 2 products to compare!
+Add products to compare
Most Helpful Review
E6406859 e328 4990 a27b 2bf1abff976c avatar
reviewer125703
Relational databases report from it central station 2018 01 27 thumbnail
Find out what your peers are saying about Oracle, Teradata, Microsoft and others in Relational Databases.
254,138 professionals have used our research since 2012.

Quotes From Members Comparing SQL Server vs Vertica

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
Pros
If backups and alerts are configured properly, I can also rely on my restoration plan.It is quite reliable in cluster configurations and has helped me to reduce downtime and improve SLAs.Comparing with other database management systems that I tried in other companies, SQL Server is quite easy to install, configure, and maintain.You could have an offsite and an onsite, and if the onsite goes down, the offsite picks it up. I like that flexibility to provide continuing operations.It is a simple query language. It is consistent across all versions. If you start with an older version, move to the newer version. The same code will still work.It can go easily on a virtual machine and be accommodated by a virtual machine easily. That is a plus, as not all databases can handle that.It will do clustering, so you can have two database servers looking at the same data simultaneously.There was an online system in which we had about 2500 requests to the DB per second. Every request had a completion window of one second to process and retrieve data. After switching to SQL Server, and AlwaysOn, and Snapshot, and tinkering, and configuring and tinkering, the handling capacity we measured increased to about 5000 requests per second, while the time decreased to 0.5 seconds per request.

Read more »

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.I don't need any special hardware. I can use commodity hardware, which is nice to have in a commercial solution.Vertica is a columnar database, this support our developments in analytics, advanced analytics, and ETL process with large sets of data.Partition and join back to node are easy and simple for DBAs.DBAs don’t need to add a partition every month/quarter like with other DBs.Vertica enabled us to close large deals. Customers with large data sets had to be migrated from PostgreSQL to Vertica due to performance.The fast columnar store database structure allows our query times to be at least 10x faster than on any other database.We are able to integrate our Vertica data warehouse with Tableau to create numerous reports quickly and efficiently.

Read more »

Cons
I would appreciate a dark theme for SQL Server Management Studio and ability to add databases with TDE enabled into availability groups.It pesters you to update the Client every month when there is nothing new that you really need to add, but it is constantly pestering you. I do not care for it.Only one CPU core can be used. Can’t move a database between servers easily. Can’t use triggers.As a software developer, it can be hard to do something in Oracle that is SQL Server specific, and vice-versa, sometimes.One stability issue I encountered was the deadlocking between calls to the same resources (tables, etc.). That was solved by row versioning.

Read more »

I believe the installation process could be streamlined.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.Very bad support, I would rate it two out of 10.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.Suboptimal projection design causes queries to not scale linearly.Metadata for database files scale okay, but metadata related to tables/columns/sequences must be stored on all nodes.Documentation has become much better, but can always use some improvement.

Read more »

Pricing and Cost Advice
This is a downside of enterprise Microsoft products.Currently, almost all of my machines are in Azure and I think it is the best way of licensing now (VM+software).​We are a Microsoft shop, so we use Active Directory. That integrates well with this product, but we did look at Oracle. We also looked at IBM. This was the best price point for us for what we were getting.​​It has the easiest licensing.The free version is cumbersome to use and maintain. But $5000 for a licence is more expense than the benefit I would get from a licensed version. A licence might be worth the price to simplify management and speed up searches.

Read more »

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 first TB is free and you can use all the Vertica features. After 1TB you have to pay for licensing. The product is worth it, but be aware of this condition, and plan. The compression ratio is explained in the documentation.Start with license per 1TB. Starting from hundreds of TB there is unlimited licensing to be considered. Move historical data to HDFS/S3 which are significantly cheaper or even free.Work with a vendor, if possible, and take advantage of more aggressive discounts at mid-fiscal year (April) and fiscal year-end (October).​

Read more »

Relational databases report from it central station 2018 01 27 thumbnail
Find out what your peers are saying about Oracle, Teradata, Microsoft and others in Relational Databases.
254,138 professionals have used our research since 2012.
Ranking
RANKING
Views
16,517
Comparisons
9,878
Reviews
21
Followers
991
Avg. Rating
8.7
Views
22,468
Comparisons
9,087
Reviews
52
Followers
1,303
Avg. Rating
8.1
Top Comparisons
Top Comparisons
Teradata
Compared 15% of the time.
Sap065658 logo 300x300 0r 01
Compared 14% of the time.
Jt hjyjg 400x400
Compared 8% of the time.
See more SQL Server competitors »
Jt hjyjg 400x400
Compared 14% of the time.
Teradata
Compared 12% of the time.
Pivotal logo
Compared 10% of the time.
See more Vertica competitors »
Also Known As
Also Known AsMicrosoft SQL Server, MSSQL, MS SQLMicro Focus Vertica, HPE Vertica, HPE Vertica on Demand
Website/Video
Website/VideoMicrosoft
  • Vendor 7622 screenshot 1519557687
Micro Focus
  • Vendor 7619 screenshot 1516468546
OverviewQuestionmark icon
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.

Sample Customers
Sample CustomersMicrosoft 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 IndustriesQuestionmark icon
Top Industries
REVIEWERS
Software R&D Company
14%
Transportation Company
10%
Comms Service Provider
10%
Retailer
10%
VISITORS READING REVIEWS
Software R&D Company
18%
Financial Services Firm
14%
Transportation Company
6%
Government
6%
REVIEWERS
Marketing Services Firm
23%
Software R&D Company
19%
Media Company
16%
Comms Service Provider
13%
VISITORS READING REVIEWS
Financial Services Firm
23%
Comms Service Provider
13%
Marketing Services Firm
10%
Media Company
10%
Company SizeQuestionmark icon
Company Size
REVIEWERS
Small Business
32%
Midsize Enterprise
34%
Large Enterprise
34%
VISITORS READING REVIEWS
Small Business
42%
Midsize Enterprise
21%
Large Enterprise
37%
REVIEWERS
Small Business
30%
Midsize Enterprise
26%
Large Enterprise
44%
VISITORS READING REVIEWS
Small Business
25%
Midsize Enterprise
25%
Large Enterprise
50%
Relational databases report from it central station 2018 01 27 thumbnail
Find out what your peers are saying about Oracle, Teradata, Microsoft and others in Relational Databases.
Download now
254,138 professionals have used our research since 2012.
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.

Sign Up with Email