A global tag that covers all the How-To posts in the blog :)
Some useful SQL that lets you find how much disk space your database and tables are actually using.
Useful SQL to create a reference table of human generations like Millennial, Generation X, Baby Boomer etc with start and end dates.
This SQL lets you find all the tables in a particular database or your user area (your personal database) in Teradata, or table names that match a pattern.
How to compare two timestamps in SQL and express the result in hours.
How to count unique values in a table or other data range in Excel. Includes a quick method for numbers, and a slower generic method that works with text.
How to find the number of AMPs and Nodes in a Teradata installation using a simple SQL query.
This SQL creates a series of commands that can be used to DROP (aka delete) all the TABLES that match a pattern or username.
Explains how to use SQL to check if a table already exists. Very useful to check prior to dropping a table, or for volatile tables if you re-run SQL.
As a data exploration tool, Tableau is second to none, but sometimes the SQL it generates to access SQL databases is just eye watering. Work