Archive

Fixing Skewed Joins in Teradata with Salting — When PDPR Fails

In Teradata, a query can run perfectly for weeks and then suddenly collapse with a spool-space error.  You open VIEWPOINT, and one AMP is…

Rounding Differences Between Teradata and Snowflake

One of the smallest but most persistent sources of data mismatches during a Teradata-to-Snowflake migration comes from rounding.

💡 Why Locking Costs You Time in Teradata — and Money in Snowflake

When we talk about query performance, locking is one of those invisible forces that decides whether your warehouse flies or crawls.

Teradata’s Semicolon Magic Explained — and Why Snowflake Doesn’t Need It

1. The Forgotten Performance Trick: A Semicolon That Saves Time

Understanding Skew in Teradata and Snowflake

Performance degradation caused by uneven workload distribution is one of the oldest and most persistent challenges in parallel data…

Why the Same UPDATE Means Something Entirely Different in Teradata and Snowflake

At first glance, an UPDATE looks universal. In reality, it’s one of the most misleading similarities between Teradata and Snowflake.

Teradata Hybrid: Bridge or Destination?

For many years, Teradata was the undisputed leader in large-scale data warehousing. Banks, insurers, and telcos built their most critical…

Teradata vs. Snowflake: Why GROUP BY Performance Differs at Scale

Migrating Bulk Loads from Teradata to Snowflake

Big files, real risks, and how not to overspend

Skewed Joins, Straight Answers: A Guide for Snowflake/Teradata Teams

Snowflake’s physical join execution is predominantly hash-based. In practice you’ll observe hash-join variants with two distributions: