327 technical articles on Teradata, Snowflake, Databricks, SQL tuning and data warehouse architecture — written from production experience, not vendor decks.
Learn about tactical workload tuning in Teradata, which requires unique skills and tools. This article covers the skills needed to optimize tactical queries and highlights the difference between tactical and decision support workloads. Discover the Tactical Workload Toolkit and how to use join indexes for optimization.
Teradata Active System Management (TASM) offers dynamic workload management features that allow workload adaptation based on system conditions. Learn more here.
Teradata Viewpoint is a web-based tool for monitoring and managing Teradata data warehousing systems. This article explores the tool’s functionalities and how to utilize it for monitoring and managing your Teradata system. What is Teradata Viewpoint? Viewpoint combines installed portlets for authorized monitoring and administration. Available actions depend on portlets, roles, collectors, database integration and …
Introduction To round up decimal values in Teradata, use the CEILING function. It is efficient and accurate. This blog post will show how to use the CEILING function in Teradata to simplify data processing tasks. Understanding the Teradata CEILING Function The CEILING function in Teradata is a built-in mathematical function that takes a numeric value …
Learn how to improve your data quality and consistency with the Teradata TRIM function. Remove unwanted spaces and characters for more accurate analysis.
Learn how to enhance the efficiency and potency of Teradata queries using the CURRENT_DATE function. Discover how to filter data and calculate time intervals with ease.
Learn the most essential Teradata SQL statements and functions in this article. From CREATE TABLE to Teradata-specific hashing functions, enhance your data manipulation and analysis capabilities on the platform. Whether you’re a beginner or an experienced user, this guide will help you master Teradata SQL skills.
Compare Teradata and Snowflake architecture, scaling, costs and migration risks. Includes VantageCloud Lake, hybrid tables and a workload evaluation checklist.
Teradata Querygrid is a Teradata database management system component that enables users to retrieve data from various sources and conduct distributed queries. This article examines the Teradata Querygrid concept, its advantages, and its application in accessing and querying data from heterogeneous sources. What is Teradata Querygrid? Teradata Querygrid is a feature of the Teradata database …
Learn how to detect and prevent Teradata skewing, one of the main causes of slow query performance. Discover the different types of skew and how to analyze tables, joins, and column values to detect and resolve issues. With practical tips and example queries, this article is a must-read for performance tuners and database administrators.
We count visits without cookies and without storing anything on your device. With your permission, we also use Google Analytics for our Google Ads integration and remember which campaign brought you here. We do not record sessions. You can decline and still use the site. Privacy details.