We performed a comparison between SQL Server and Teradata based on real PeerSpot user reviews.
Find out in this report how the two Relational Databases Tools solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.
"I like the availability group functionality. We are setting up more clusters using availability groups. The enterprise licensing or Software Assurance makes it a little bit cheaper as well. It is nice to have that read-only copy for reporting and everything else."
"It's a good learning environment, it's easy enough to learn and understand. Anybody that picks up the language early on will be able to develop in it."
"It is secure, and it is fast. For our present database size, we are using the Always-On feature on SQL Server so that our transactions are replicated among three servers. If one server goes down, we can find the data from other servers. We have benefited from this feature."
"SQL Server is very scalable because we use it across a couple of different types of applications, such as micro-infrastructure setup and server farm."
"SQL Server's performance is fine."
"The initial setup isn't overly complex."
"It's great that the nodes are synchronized so if you lose one it automatically moves to another."
"Since we can automate most of our tasks, it means that the management is very easy."
"Teradata features high productivity and reliability because it has several redundancy options, so the system is always up and running."
"It's a pre-configured appliance that requires very little in terms of setting-up."
"There are several features of Teradata that I like. One of the most basic is the indexes. I also like that it provides lower TCO. It also has the optimizer feature which is a good feature and isn't found in other legacy systems. Parallelism is also another feature I like in Teradata because when you are running or hosting on multiple systems, you have this shared-nothing architecture that helps. Loading and unloading in Teradata are also really helpful compared to other systems."
"The most valuable features are the large volume of data and the structuring of the data to optimize it and get very optimal data warehouse solutions for customers."
"The performance is great, we are able to query our data in one operation."
"I've never had any issues with scalability."
"It's very, very fast"
"Teradata's most valuable feature is that it's easy to use."
"Their datatypes need improvement."
"The treatment of database storage could be improved."
"SQL Server could improve by being more user-friendly, it is still geared towards specialists. Additionally, the monitoring system is difficult to use, not everyone can use it well. The configuration should be able to be done through the GUI."
"It may be a licensing issue, but sometimes its operating speed becomes slow if we have multiple users. It's lacking some performance, but it's acceptable because we have a heavy load."
"The licensing costs are very high."
"The scalability could be better."
"The solution needs to be more secure. It's lacking, compared to, for example, Oracle."
"It would be great if we were able to run it on multiple operating systems and not only stick with Windows."
"I've been using the same UI for 20 years in Teradata. It could use some updating. Adding more stability around Teradata Studio would be outstanding. Teradata Studio is a Java-based version of their tool. It's much better now, but it still has some room for improvement."
"Apart from Control-M, it would be nice if it could integrate with other tools."
"Since I was working on the very basic, legacy systems, the memory thing was always a challenge. If Teradata is moving to the cloud, the space constraint or the memory issue that my company generally faces will eventually resolve, in time. What I'd like to see in the next release of Teradata is that it becomes full-fledged on the cloud, apart from better connectivity to various systems. For example, if I have to read or include a Python script, if I write some basic codes, I should be able to read even unstructured data. I know that it's not supported even in Snowflake, but at least semi-structured data support, if that can be a little more enhanced, that would be good."
"Teradata's pricing is quite high compared to Redshift, Synapse, or GCP alternatives."
"Teradata should focus on functionality for building predictive models because, in that regard, it can definitely improve."
"The scalability could be better. The on-premises solution is always more complicated to scale."
"Teradata could improve by being less complicated. There are some aspects that are not available on the Unix server and a Unix system is required to access some data, such as in case of an emergency."
"It could use some more advanced analytics relating to structured and semi-structured data."
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.
SQL Server is ranked 1st in Relational Databases Tools with 165 reviews while Teradata is ranked 5th in Relational Databases Tools with 16 reviews. SQL Server is rated 8.2, while Teradata is rated 8.2. The top reviewer of SQL Server writes "Good performance, well-priced, trivial to set up, and helpful support". On the other hand, the top reviewer of Teradata writes "Very fast with good database control and excellent support". SQL Server is most compared with Oracle Database, SAP HANA, LocalDB, MariaDB and IBM Informix, whereas Teradata is most compared with Snowflake, Oracle Exadata, Vertica, Microsoft Azure Synapse Analytics and MySQL. See our SQL Server vs. Teradata report.
See our list of best Relational Databases Tools vendors.
We monitor all Relational Databases Tools 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.