SQL
A collection of 180 issues
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
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
Improve the Performance of your Teradata System
Executing the following query may reveal that a small number of queries are responsible for consuming a significant portion of the resources in the Teradata System. Improving the performance of these queries can greatly impact the system's overall health.
Your Teradata
Achieve Incredible Teradata Join Performance
Executive summaryGUEST POST BY ARTEMIY KOZYR
Today I shed some light on how Data Warehousing lies at the core of Retail Banking operations. We will see the actual case of vital marketing process malfunction and dive deep under the surface level to comprehend data alchemy technical issues.
You will learn
Why You Need a Performance Specialist for Your Data Warehouse Project
How to Find ASCII Code of a Character Using Teradata SQL
Learn Teradata Indexing Techniques in this 2-Hour Video Course
Introduction
Teradata SQL lacks a built-in function to determine the ASCII code of a character. But fear not, for there exists a query workaround to this dilemma. This blog post will guide you through the process of using a straightforward SQL query in Teradata to find the ASCII code of