Latest blog posts
 Ordered Analytical Functions: Translating SQL Functions to Set SQL Posted 21 Jan 2014 Many experienced SQL and procedure developers use SQL functions to perform common tasks and simplify their code narratives. The function concept is a good programming technique, but adopting it literally in a Set SQL statement may force the statement to execute as a serial process; that is, it can make parallel processing impossible.  This is one reason Teradata SQL does not allow functions to access tables. 4474 views 3 comments
 Derived Tables with Ordered Analytical Functions to Translate Flat Logic Posted 06 Mar 2012 Ordered analytical functions enable parallel processing by freeing processes from flat logic. They also produce simpler Set SQL statements, which as a general rule can be expected to perform better than more complex Set SQL statements. 9301 views 0 comments
 Loops to Sets: A Brief History of Database Programming Logic Posted 01 Nov 2011 Set SQL is a way of operating on data that is radically different from historical concepts of computer programming that can be diagrammed with flow charts.  Grab a cup of coffee and review some history that will explain why the industry is mired in cursor logic and loops that cannot exploit the power of today's software and hardware. 6010 views 2 comments
 Converting Complex Procedure Logic to Set SQL Using Derived Tables Posted 10 Jul 2011 When Flat SQL looping logic involves complex processing of data elements from multiple tables, the loops can almost always be transformed into Set SQL with derived tables. By eliminating looping logic, the performance benefits of parallel processing can be exploited. 9297 views 2 comments
 Using Derived Tables as a Shortcut to Set SQL Posted 31 May 2011 The most difficult task when converting Flat SQL (cursor-based procedural code) to Set SQL involves translating complex logic and accounting for multiple data sources.  The Derived Table feature of Set SQL simplifies this process. 12824 views 5 comments
 From Flat Logic to Set Logic - a basic approach Posted 26 Apr 2011 Perhaps the easiest way to transition from a flat logic mindset to a set logic mindset is to convert some Flat SQL to Set SQL, then stare at both of them until the logical equivalence of the two approaches becomes clear. 7087 views 2 comments
 Learning to Think in Set SQL Posted 19 Apr 2011 Maximizing the full potential of Teradata's Massive Parallel Processing requires Set Processing. 6294 views 2 comments