Recently I was asked to provide an inventory of a production Teradata system that included a list of all user created objects and as much information about the objects that I could gather included perm space usage, row counts, and object type. Two of the three could easily be gathered using the data dictionary tables […]
Continue reading →A user over at TeradataQuestions recently asked a if there was a table in Teradata that allowed you to track the growth of tables or databases over time. The short answer to this question was no. The data dictionary tables in Teradata only provider the current information about tablesizes and the current and max sizes […]
Continue reading →
If you are looking for Teradata developer or DBA resources, you are not going to find an equivalent to SQLServerPedia yet. The Teradata developers and DBA’s aren’t found tweeting about join indexes, DBQL, or fallback, nor are they blogging about multi-value compression, UDFs, or Teradata Active System Management (TASM) on a regular basis. That doesn’t […]
Continue reading →