Compare SQL Server vs. Teradata

Cancel
You must select at least 2 products to compare!
SQL Server Logo
21,523 views|16,839 comparisons
Teradata Logo
17,796 views|12,992 comparisons
Most Helpful Review
Anonymous User
Use Teradata? Share your opinion.
Find out what your peers are saying about SQL Server vs. Teradata and other solutions. Updated: July 2021.
521,189 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 »

"It is a stable program.""The functionality of the solution is excellent.""It's a pre-configured appliance that requires very little in terms of setting-up.""The performance is great, we are able to query our data in one operation.""I like this solution's ease of design and the fact that its performance is quite good. It is stable as well.""The flexibility in design is very good."

More Teradata 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 »

"An additional feature I would you like to see included in the next release, is that it needs to be more cloud-friendly.""I'm not sure about the unstructured data management capabilities. It could be improved.""It could use some more advanced analytics relating to structured and semi-structured data.""I would like to see more integration with many different types of data.""The scalability could be better. The on-premises solution is always more complicated to scale.""Teradata should focus on functionality for building predictive models because, in that regard, it can definitely improve."

More Teradata 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 »

"The solution requires a license.""The price of Teradata is on the higher side, and I think that it where they lose out on some of their business."

More Teradata Pricing and Cost Advice »

report
Use our free recommendation engine to learn which Relational Databases solutions are best for your needs.
521,189 professionals have used our research since 2012.
Questions from the Community
Top Answer: I like that it's relatively stable.
Top Answer: There is a license required for this solution. One of the problems is for smaller businesses to purchases a license because it is expensive for a lot of them to afford.
Top Answer: It would be better if it had more integration with other systems.
Top Answer: I like this solution's ease of design and the fact that its performance is quite good. It is stable as well.
Top Answer: The scalability could be better. The on-premises solution is always more complicated to scale. The flexibility could be improved. The product is good if you know what you're planning to do. If you're… more »
Top Answer: We use it as a data warehouse.
Ranking
1st
Views
21,523
Comparisons
16,839
Reviews
82
Average Words per Review
465
Rating
8.2
6th
Views
17,796
Comparisons
12,992
Reviews
4
Average Words per Review
268
Rating
8.3
Popular Comparisons
Also Known As
Microsoft SQL Server, MSSQL, MS SQL
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.

Teradata's portfolio of big data analytic solutions, integrated marketing applications, and services help organizations gain a sustainable competitive advantage with data.

Offer
Learn more about SQL Server
Learn more about Teradata
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.
Netflix
Top Industries
REVIEWERS
Financial Services Firm19%
Computer Software Company12%
Manufacturing Company8%
Transportation Company6%
VISITORS READING REVIEWS
Computer Software Company25%
Comms Service Provider21%
Financial Services Firm7%
Media Company5%
REVIEWERS
Comms Service Provider27%
Energy/Utilities Company18%
Manufacturing Company9%
Financial Services Firm9%
VISITORS READING REVIEWS
Computer Software Company34%
Comms Service Provider14%
Financial Services Firm11%
Media Company5%
Company Size
REVIEWERS
Small Business42%
Midsize Enterprise21%
Large Enterprise37%
VISITORS READING REVIEWS
Small Business18%
Midsize Enterprise10%
Large Enterprise72%
REVIEWERS
Small Business28%
Midsize Enterprise11%
Large Enterprise61%
Find out what your peers are saying about SQL Server vs. Teradata and other solutions. Updated: July 2021.
521,189 professionals have used our research since 2012.

SQL Server is ranked 1st in Relational Databases with 93 reviews while Teradata is ranked 6th in Relational Databases with 6 reviews. SQL Server is rated 8.2, while Teradata is rated 8.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 Teradata writes "Good performance, flexible, easy to tune queries, and scales well". SQL Server is most compared with SAP HANA, Oracle Database, IBM Db2 Database, LocalDB and MariaDB, whereas Teradata is most compared with Oracle Exadata, Snowflake, Amazon Redshift, Oracle Database and Microsoft Azure Synapse Analytics. See our SQL Server vs. Teradata report.

See our list of best Relational Databases vendors.

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.