Sign in Subscribe

Administration

A collection of 61 issues

Three Rules for Choosing a Technology Career

How to think about the choice when the standard path no longer reliably works. Foreword The path that worked through most of the previous decade — pick any reasonable engineering specialty, get hired into a junior role, learn the rest on the job — does not reliably work in 2026. The market

The Teradata AMP Worker Task

Introduction to the Teradata AMP Worker Task The Teradata AMP Worker Task or AWT is the heart of the AMP, responsible for executing tasks and ensuring the smooth functioning of the system. AWTs are threads that process incoming tasks in the AMP. Each AMP has a finite pool of AWTs,

Boost Your Teradata Performance - The Critical Role of NOT NULL Declarations

Introduction to Teradata Performance and NOT NULL Welcome to our latest Teradata performance blog post, a series designed to provide valuable insights into SQL queries. This article spotlights 'NOT NULL'. To delve deeper into 'NOT IN', it is crucial to comprehend a frequently neglected SQL database

A Beginner's Guide to Teradata Multiload and Fastload

Introduction to Teradata Multiload and Fastload What is the Teradata Multiload?Teradata Multiload is a utility that supports loading data (INSERT) and other DML statements (UPDATE, DELETE, UPSERT). All DML statements are executed optimally, and changed data blocks are written only once. Furthermore, Teradata can process several tables at once.

Understanding Teradata Statistics Histograms: How the Optimizer Estimates Cardinality for WHERE Conditions

Teradata Statistics Histograms - A Short Introduction Many are familiar with the Optimizer's statistical confidence levels. I was recently surprised to discover that a "high confidence" rating does not guarantee a fully accurate estimation (provided the statistics collected are not stale). While I remain hopeful that

Teradata Express Edition: Converting from VMware to VirtualBox

The Teradata Express Edition is a great opportunity to experiment with a fully functional Teradata system. It can be downloaded from https://downloads.teradata.com/download/database. Unfortunately, only VMware is supported as the virtualization software. As a user of Oracle's VirtualBox, I looked for a way to

Understanding Teradata Locking: Types and Granularity

Learn about locking in Teradata to ensure data integrity and consistency. Teradata automatically selects the best lock for each situation to prevent data inconsistencies.

Understanding Teradata Flow Control Mode for Efficient Workflow Management

Introduction Teradata efficiently manages complex workflows by distributing and expanding processes across numerous AMPs. However, when an AMP's maximum capacity is reached, it can initiate flow control mode. This blog post delves into Teradata's Flow Control Mode, its impact on performance, and effective monitoring and management

Introduction to TPT Teradata: Streamline Your Data Loading

Learn about Teradata's Parallel Transporter Utility (TPT), the all-in-one tool that combines Fastload, Multiload, TPUMP, BTEQ, and Fastexport functionalities. Discover the benefits of TPT's consistent syntax and parallelism, as well as a comprehensive overview of its operators.

Understanding Deadlocks in Teradata: Prevention and Handling Strategies

What are Deadlocks in Teradata? Deadlocks arise when two transactions hold locks on database objects required by the other transaction. Here is an example of a deadlock: Transaction 1 locks some rows in Table 1, and transaction 2 locks some rows in Table 2. The next step of transaction 1