If you know Teradata, learning Redshift, Snowflake, BigQuery, etc. is ridiculously easy and the opportunity to make money now that the disillusionment sets in:SQL Tuning in the age of cloud computing

Hi,Many times a simple rewrite of the query can achieve enormous performance improvements. In this article by Artemios Vogiatzis, we discuss two cases revolving around duplicates and calendars:Go to the articleBest Regards,Roland - DWHPro

In this article, I will show you how to keep small tables in memory using your customized hash map to optimize performance for certain workloads.I have used this method myself in a cursor of a stored procedure to minimize the runtime of several thou...

Hi,Are you looking for a one-line script with which you can easily copy tables between different Teradata systems or databases on the same Teradata system? On our website, you can find an article that shows the details. A video also demonstrates the...

Are you annoyed that Teradata Express Edition is only available for Level 2 hypervisor software (VMWare, VirtualBox) with all the disadvantages? I'll show you how you can easily migrate Teradata Express Edition to a Level 1 hypervisor at no cost and...

Hi,In this video, we do some experiments to highlight the performance differences between SET and MULTISET tables:Watch the video!Roland - DWHPro

In this article, I'll show you the most efficient way to read data from an S3 object store. The performance difference when not filtering correctly can be enormous: Filter efficiently with Teradata NOSGoto Youtube Channel

With NOS, Teradata Vantage offers an easy way to offload cold data to cheap S3 object stores (AWS S3, Azure Blob, Google Storage) and still have it available online. I show you in this video how it works: Watch the video!

In this article, we will give you an introduction to how Teradata can access external data stored in object stores, which formats and cloud providers are available, and how Teradata NOS differs from Teradata Querygrid Technology:What is the Teradata...

Do you have cold data that you would like to offload to make room on your Teradata system? If you want to query this data, it should still be available quickly. In this video, I show you how this can be achieved:Watch the video!