Subscribe to Terdata Developer Exchange - RSS feed for all blogs Latest blog posts
27 Aug 2012

Teradata 14.0 offers some very helpful enhancements to the statistics collection process.   This posting discusses a few of the key ones, with an explanation of how these enhancements can be used to streamline your statistics collection process and help your statistics be more effective.

For more detail on these and other statistics collection enhancements, please read the orange book titled Teradata 14.0 Statistics Enhancements, authored by Rama Korlapati, Teradata Labs. 

15 Aug 2012

How do you pick the number of sessions to assign to your utility jobs?  Chances are you guess.  In Teradata 13.10 the task of deciding the number of sessions has been moved inside the database, meaning one less thing for you to worry about.  Read on for a quick intoduction to how this feature works.

16 Jul 2012

Starting in Teradata 13.10, there is a single delay queue for all throttles.  This means that queries delayed by system throttles will reside in the same queue as queries delayed by workload throttles.  In earlier releases, delay queues were set up independently by type of throttle, and each workload throttle had its own dedicated queue.   

Bringing together all delayed objects into a single queue streamlines the entire throttling experience and makes it easier and more accurate to manage internally.  However, as a side-effect, the DelayTime field in DBQL needs a second look.  DelayTime takes requires slightly different interpretation in 13.10 than you gave it in earlier releases.

10 Jul 2012

This article introduces jQuery.on and as the preferred methods for binding events in jQuery 1.7+.

21 Jun 2012

We are pleased to announce the availability of 4GB and 1TB versions of Teradata Express 14.0 for VMware, joining the previously available 40GB version. Please visit the Teradata Express for VMware download page or read the launch announcement for more details.

13 Jun 2012

If you are using utility throttles in Teradata 13.10 to manage concurrency of your load jobs, any delay action against the utility job's unit of work will happen cleanly at the beginning of the load job.  However, there may be times where the load activity can be unexpectedly held up after the utility has begun execution.  This posting describes the particular conditions under which this may happen, and points to a simple adjustment you can make to keep it from happening again.   

13 Jun 2012

Well not exactly printf(), but still pretty darn cool. I consider myself a decent JavaScript programmer with a fair amount of debugger knowledge. However, I stumbled across an interesting bit of new (to me) information last night. Maybe everybody else is already hip to this. If so then I am an uninformed idiot; well I guess this isn’t exactly the straw that broke the camel’s back on that front. Anyway…

Are you tired of writing the following?

08 Jun 2012

Data temperature, a metaphor for frequency of access, is used by Teradata Virtual Storage (TVS) to automatically move data throughout the spectrum of storage media (e.g. from HDD to SSD) based on performance needs. Teradata believes that every organization possesses a wide range of value in the data they use for analytics. Consequently, we are pursuing a strategy to match the cost of storage to the value of data in the organization – using all classes of storage simultaneously (in-memory, SSD, performance disk, capacity disk, and archives).

04 Jun 2012

This blog discusses tips, tricks, and use cases for Teradata Viewpoint's "Rewind" feature. Hopefully this blog will give you some new ideas on more efficient navigation and different ways of utilizing rewind that you may have overlooked in the past.