V2R5 Query Log Functionality
If you have a lot of ad hoc users writing their own SQL, query logging is a necessity, so how can Query Log help?
View Tip

How do you write a query to determine the average daily sales value?
View Tip

How would you adjust the time on a Teradata system if the 'get time' Ferret command shows the time as 03:06:11, whereas the exact time is 03:36:11?
View Tip

How do you declare a variable inside a Teradata macro?
View Tip

Is there a quick, low-impact way to determine whether a Teradata table is empty or if it contains rows and you don't always know the column names or indexes?
View Tip

When creating circular referencing tables in Teradata is the following relation possible, or should the database prevent such a relation from being created?
View Tip

Please explain the BYNET, Teradata's interconnect component.
View Tip

Teradata supports "logical data marts". What does that mean? How is it architected?
View Tip

Can Teradata support star schemas?
View Tip

How is data redistributed when I add new hardware to an existing Teradata configuration?
View Tip

What's the workload difference between tactical and strategic queries?
View Tip

In Teradata, does a GROUP BY clause imply a grouping of similar values when the output is displayed? In other words, if there is no aggregate function, will a GROUP BY clause allow you to see the similar values grouped together as shown below, or do you have to use the ORDER BY clause?
View Tip

In addition to the ADD_MONTHS function, how can you go to the beginning/end of the month in queries which involve the date field in the WHERE condition?
View Tip

How can you determine skewness in a table using tools such as Teradata Manager and Teradata Administrator?
View Tip

What are alternatives to regulate access privacy information in databases - specifically column level data security?
View Tip