Subscribe to Terdata Developer Exchange - RSS feed for all blogs Latest blog posts
14 Apr 2010

In my opinion stored procedures can be used to enforce standards for commonly used processes and to avoid the same code to be copied out into multiple scripts/programs creating a maintenance nightmare.

But let's list some of the pro's & con's associated with stored procedures.

30 Mar 2010

Following are some basic scalar UDFs we've written to deal with strings of text. We figured that as frustrating as it must be for us, so is it for everyone else - ergo some code that works.  If you can - please return the favor by posting some of your general solutions to frustrating problems in the Extensibility forum.

15 Mar 2010

Last month I talked about things that don’t honor a CPU limit, and explained what a CPU limit is. This month I’d like to look at CPU limits from a slightly different perspective—What happens when you define CPU limits at multiple levels? For example, you may already have a system level CPU limit on your platform, but now you’d like to use CPU limits on one or two of your resource partitions (RP) as well. Yes, you can do this. Read along with me while I explain to you what you can expect.

08 Mar 2010

A bug fix patch for Elastic Marts Builder (version 0.9.1) is now available.  This release addresses an installation issue and various issues with file validation.  You can download the latest version here.

05 Mar 2010

It's been a busy start to the year for Developer Exchange and its related sites. The biggest change has been the long-awaited integration of the legacy Teradata Discussion Forums with the DevX Forums at the new Teradata Forums site. We've migrated across all content and user accounts, so if you've previously posted in the Teradata Discussion forums, all your history is available on the new site. Also, we've rearranged and merged some of the forums so that the purpose of each forum is clearer. For more details on the changes, see Teradata Forums migration imminent, or discuss the changes here. Another significant improvement is that we've enabled HTTPS support for the sensitive areas of the site, such as login, registration, and profile update.

03 Mar 2010

Preparing for Teradata 12 Certification? For authorized training material and important program updates, please visit the Teradata Certified Professional Program at

26 Feb 2010

First off, my apologies on slacking in my series of blogs on cool Viewpoint features. Was the last one really November? Spilt milk at this point, so let's get to it. One of the key considerations to Viewpoint development planning is "ease of use" and the desire to make Viewpoint as intuitive as possible. Although we believe we have been successful in this initiative, we still provide additional assistance features within Viewpoint to help everyone along.

So this blog is on learning how to learn in Viewpoint and what features are available in promoting this.

22 Feb 2010

This blog was started to discuss Chris Anderson’s Long Tail concepts and how they relate to Enterprise Data Warehouse (EDW) implementations. Well… Mr. Anderson (‘No,” not a Matrix reference) has recently published a new article in “Wired” magazine, “In the Next Industrial Revolution, Atoms Are the New Bits.”

11 Feb 2010

Since the launch of Developer Exchange several months ago, we have been operating with two sets of forums: the legacy Teradata Forums at (which we'll refer to as the Legacy Forums), and the new DevX-hosted forums at (i.e. the new Teradata Forums). We are now about to permanently retire the legacy forums, and migrate the legacy content to the new site.

So, what's happening exactly?

04 Feb 2010

Maybe you want to ensure that your sandbox applications never use more than 2% of the total platform CPU. No problem! Put a CPU limit of 2% on them. Or maybe you’ve got some resource-intensive background work you want to ensure stays in the background. CPU limits are there for you. But if you plan to use CPU limits as part of your workload management scheme, be aware that there are some database operations that simply won’t obey the limits. So let’s take a look at what those special cases are and why they’re allowed to violate the rules.