In this article, I show you how to migrate the VMWare image of Teradata Express Edition on a Level 1 ...

Teradadata Express on a Level 1 Hypervisor

What are Deadlocks in Teradata? Deadlocks occur when each of two transactions holds the lock on a database object the ...

Minimize Teradata Deadlocks!

Sometimes you can’t avoid implementing a certain functionality by means of a cursor in a stored procedure. Recently I had ...

Teradata Stored Procedure Tuning with MAPS

Teradata ORDER BY and PerformanceIf we chose a simple sort method, all rows would have to be available in one ...

How Teradata ORDER BY affects your query performance

A Teradata Transient Journal is a dictionary table maintained across the whole system to protect transactions against system failures and ...

The Teradata Transient Journal

Introduction to Teradata Sparse Maps The Teradata hashing architecture and how AMPs are used to evenly split tables for maximum ...

Lightning-fast queries thanks to Teradata Sparse Maps

This article will show the key architectural differences between Teradata and SQL Server and the similarities and performance implications. The ...

Teradata versus SQL Server – Tuning Considerations

What is a Teradata AMP? AMP is the abbreviation for Access Module Processor. Each Teradata AMP is a Linux process ...

The Teradata AMP and its Worker Tasks (AWT)

The bottleneck of database systems has always been accessing the data. As soon as the data is in the main ...

Teradata WAL – The Write-Ahead Logic

Teradata moved towards the cloud to avoid losing the connection to modern cloud databases. I will show you the AWS ...

Teradata AWS – In The Cloud