DWHPro helps thousands of visitors every month to become experts in Teradata and data warehouse design and operations by Roland Wenzlofsky

DWHPro Jan 3, 2023

Improving SQL Performance with Simple Query Rewrites: Dealing with Duplicates and Business Calendars

The Teradata flavor of SQL is still, in principle, a declarative language. Hence, there can be multiple ways to describe…

Read article →
DWHPro Dec 25, 2022

Streamline Your Tasks with Teradata Macros: Reusable Blocks of SQL Code for Improved Efficiency

Learn how Teradata macros can improve your database efficiency with reusable blocks of SQL code. Create macros once,…

Read article →
DWHPro Dec 25, 2022

Teradata DBQLOGTBL

Teradata DBQLOGTBL is a system table in the Teradata database management system that stores log data for all queries…

Read article →
DWHPro Dec 25, 2022

Teradata Querygrid

Teradata Querygrid is a feature of the Teradata database management system that allows users to access data from…

Read article →
DWHPro Dec 25, 2022

Teradata Viewpoint Introduction

Teradata Viewpoint is a web-based tool that allows users to monitor and manage their Teradata data warehousing…

Read article →
DWHPro Oct 23, 2022

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 hypervisor.…

Read article →
DWHPro Oct 20, 2022

Filter efficiently with Teradata NOS

Teradata NOS facilitates querying data in an S3 object store with ease. To attain maximum performance, partitioning…

Read article →
DWHPro Oct 15, 2022

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…

Read article →