Sign in Subscribe

SQL

A collection of 180 issues

Unlocking the Power of Teradata Macros: Features, Creation, and Execution

What is a Teradata Macro? The Teradata macro executes multiple SQL queries in a single transaction, ensuring that all requests are successful or changes to database objects are rolled back. Want more practical data engineering analysis like this? Join DWHPro Letters and get field-tested notes on Teradata, Snowflake, AI, migrations,

Two Methods for Generating Number Ranges in Teradata

Method 1, avoiding any helper tables or functions which are only available in new releases of Teradata: WITH RECURSIVE NumberRanges(TheNumber,TheString) AS ( SELECT 1 AS TheNumber,casT(1 as VARCHAR(500)) as TheString FROM ( SELECT * FROM (SELECT NULL AS X) X ) DUMMYTABLE UNION ALL SELECT TheNumber + 1 AS TheNumber,

Understanding Partial Group By: Reducing Join Costs with Aggregation Optimization

Why Teradata's LIKE operator behaves differently for CHAR and VARCHAR columns

Have you observed the different behavior of the Teradata LIKE operator when applied to a CHAR or VARCHAR data type column? Consider the following table as an illustration: Creating a table: CREATE TABLE TheLikeTest ( TheVarchar VARCHAR(20), TheChar CHAR(20) ); To illustrate, we will add a single row. Want more

Advanced GROUPING Methods in Teradata SQL: GROUP BY GROUPING SETS, ROLLUP, and CUBE

Teradata SQL and Advanced GROUPING Functions What advanced GROUPING methods are there in Teradata SQL?- GROUP BY GROUPING SETS - GROUP BY ROLLUP - GROUP BY CUBE What is GROUP BY CUBE used for?One or more columns are used to group across multiple dimensions. If grouped by n

Optimizing Teradata System Performance: Identify and Improve Resource-Consuming Queries

Achieve Incredible Teradata Join Performance

Why You Need a Performance Specialist for Your Data Warehouse Project

How to Find ASCII Code of a Character Using Teradata SQL

This course focuses on Teradata indexing techniques. In this two-hour video, you will learn about Teradata's architecture and Full Table Scans, different types of Primary Index Access such as UPI and NUPI, diverse Secondary Index Access including USI and NUSI, and Join Indexes. You will gain the comprehensive

Learn Teradata Indexing Techniques in this 2-Hour Video Course