Compare SQL Server vs. Teradata

You must select at least 2 products to compare!
SQL Server Logo
24,020 views|20,525 comparisons
Teradata Logo
21,843 views|16,237 comparisons
Most Helpful Review
Find out what your peers are saying about SQL Server vs. Teradata and other solutions. Updated: September 2020.
437,557 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:

The most valuable features are ease of use and the integration with Single Sign On (SSO), as well as with other Microsoft products.SQL Server is a stable product.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.The features that we have found the most valuable are reliability, availability perspective, and current scalability.Very good security features.The feature that I have found most valuable is that it is easy to code.It helps with moving the design of the database into reality.SQL is very easy to manage.

More SQL Server Pros »

It is a stable program.The most valuable features are the Shared-nothing architecture and data protection functionality.The feature that we find most valuable is its ability to perform Massive Parallel Processing.

More Teradata Pros »

The performance needs some improvement and it needs more features integrated into it.The number of concurrent users is too limited and other databases are better than SQL in this regard.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.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.Query optimitzer could be simplified.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 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.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.

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.The user interface needs to be improved.I would like to see an improved Knowledge Base on the web.

More Teradata Cons »

Pricing and Cost Advice
Pricing is reasonable for small organizations, but the scaling increases the price.SQL Server is a cost-effective solution for a small database.It is expensive, but you get what you pay for.Since we are a cloud-based company, there is AWS pricing on top of the SQL Server pricing. The Enterprise Edition can typically sell from around $1000 dollars a month, which is not cheap. Then, there is an additional one-time Windows cost, based on the code, which can go anywhere from $30,000 to $40,000 for the license.

More SQL Server Pricing and Cost Advice »

The price needs to be more competitive as Hadoop, Redshift, Snowflake, etc are constantly making way into EDW space.

More Teradata Pricing and Cost Advice »

Use our free recommendation engine to learn which Relational Databases solutions are best for your needs.
437,557 professionals have used our research since 2012.
Questions from the Community
Top Answer: The availability is the most valuable feature. It has high availability. It also has good performance.
Top Answer: In terms of improvement, it could use more integration with other products.
Top Answer: My primary use case is for data mining and processing data from plants. It's normally just for databases for the systems.
Top Answer: It is a stable program.
Top Answer: What really needs to improve, is their general cloud services. That is their biggest downfall at the moment.
Top Answer: We are only consultants, so we don't use the program ourselves.
Average Words per Review
Avg. Rating
Average Words per Review
Avg. Rating
Popular Comparisons
Compared 17% of the time.
Compared 13% of the time.
Compared 10% of the time.
Compared 7% of the time.
Compared 16% of the time.
Compared 12% of the time.
Compared 10% of the time.
Compared 6% of the time.
Compared 6% of the time.
Also Known As
Microsoft SQL Server, MSSQL, MS SQL

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.

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
Computer Software Company13%
Financial Services Firm10%
Manufacturing Company10%
Comms Service Provider7%
Computer Software Company37%
Comms Service Provider10%
Media Company9%
Comms Service Provider38%
Energy/Utilities Company13%
Financial Services Firm13%
Logistics Company13%
Computer Software Company48%
Media Company9%
Comms Service Provider8%
Financial Services Firm5%
Find out what your peers are saying about SQL Server vs. Teradata and other solutions. Updated: September 2020.
437,557 professionals have used our research since 2012.
SQL Server is ranked 1st in Relational Databases with 16 reviews while Teradata is ranked 6th in Relational Databases with 3 reviews. SQL Server is rated 8.2, while Teradata is rated 8.0. The top reviewer of SQL Server writes "Stable with a straightforward setup and the capability to scale". On the other hand, the top reviewer of Teradata writes "It is stable but it should be more cloud-friendly and scalability is poor". SQL Server is most compared with SAP HANA, Oracle Database, IBM Db2 Database, MariaDB and IBM Netezza Performance Server, whereas Teradata is most compared with Oracle Exadata, Snowflake, Amazon Redshift, Oracle Database and Apache Hadoop. 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.