Using... & How To's

A global tag that covers all the How-To posts in the blog :)

Using Teradata SQL: Check the size of tables in a database

Some useful SQL that lets you find how much disk space your database and tables are actually using.

SQL
Jamie Whitehorn

Using Teradata SQL: Create a reference table for human generations

Useful SQL to create a reference table of human generations like Millennial, Generation X, Baby Boomer etc with start and end dates.

SQL
Jamie Whitehorn

Using Teradata SQL: How to find all the tables in a database or user area

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.

SQL
Jamie Whitehorn

Using Teradata SQL: Find the difference between two timestamps and express as hours

How to compare two timestamps in SQL and express the result in hours.

SQL
Jamie Whitehorn

Using Excel: How to count unique values

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.

Using... & How To's
Jamie Whitehorn

Using Teradata SQL: How to find the number of AMPs and Nodes

How to find the number of AMPs and Nodes in a Teradata installation using a simple SQL query.

SQL
Jamie Whitehorn

Using Teradata SQL: How to drop (aka delete) a lot of tables at once

This SQL creates a series of commands that can be used to DROP (aka delete) all the TABLES that match a pattern or username.

SQL
Jamie Whitehorn

Using Teradata SQL: How to check if a table exists

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.

SQL
Jamie Whitehorn

Using Tableau: Massive queries and slick 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

Tableau
Jamie Whitehorn