Teradadata Express on a Level 1 Hypervisor

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

Read More
Teradadata Express on a Level 1 Hypervisor

Filter efficiently with Teradata NOS

Teradata NOS offers us the possibility to easily query data stored in an S3 object store. To achieve optimal performance, ...

Read More
Filter efficiently with Teradata NOS

Teradata NOS – Native Object Store – Reading

Teradata Vantage has also made its move into the public cloud. Teradata Vantage is now available in AWS, Microsoft Azure, ...

Read More
Teradata NOS – Native Object Store – Reading

No more Teradata Spool Space Problems

Teradata Spool Space Introduction What is Teradata Spool Space?Teradata Spool Space is a workspace that Teradata uses to store temporary ...

Read More
No more Teradata Spool Space Problems

Teradata and the Memory Hierarchy

...

Read More
Teradata and the Memory Hierarchy

Minimize Teradata Deadlocks!

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

Read More
Minimize Teradata Deadlocks!

Tuning with the Teradata TD_WhichMax Function

What is the Teradata TD_WhichMax Function? Each Teradata release adds new SQL features to make our lives easier. While some ...

Read More
Tuning with the Teradata TD_WhichMax Function

Teradata Tuning with PERIOD Data Type

This article will show a case study from my past projects. It is an implementation in which, from a row ...

Read More
Teradata Tuning with PERIOD Data Type

Teradata Stored Procedure Tuning with MAPS

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

Read More
Teradata Stored Procedure Tuning with MAPS