Teradata – Most Currently Updated Stats
This is a quick query that I use to check if the on the stats job that ran over night. Much faster then running the “SHOW STATISTICS” for each table. … Continue Reading →
Resolutions found with SQL Server and other types of databases
This is a quick query that I use to check if the on the stats job that ran over night. Much faster then running the “SHOW STATISTICS” for each table. … Continue Reading →
Recently I was asked to update a couple of views on a Teradata database. This script was an easy way to verify that the Teradata views’ timestamp for the DDL … Continue Reading →