#DateWhereItemComment
1118 May 2011 @ 12:27 PDTDatabasePartitioned Primary Indexes (PPI): Getting StartedThere's no difference between UPI and NUPI, both are always a single-AMP access. The data of the PI column(s) of a row is hashed to a 32-bit value and the row is sent the single AMP responsible fo...
1016 May 2011 @ 12:40 PDTÜber SQLMissing Functions: DENSE_RANKOf course, just try it :-) Dieter
901 Apr 2011 @ 07:27 PDTÜber SQLGlobal and session level parameters in SQLPlease post questions like this in the forum. Answered in http://forums.teradata.com/forum/analytics/select-failed-3706-syntax-error-expected-something-between-and-the-select-keyword Dieter
828 Mar 2011 @ 11:39 PDTÜber SQLGlobal and session level parameters in SQLHi Abbas, you should post questions like this in the forum. Standard SQL ROW_NUMBER exists, but can't be used in UPDATEs. ROWID could be used, but it's use is disabled by default and only the ...
716 Mar 2011 @ 05:20 PDTÜber SQLGlobal and session level parameters in SQLHi Carlos, you're correct. This happens, when you modify code and do cut&paste. I changed it, thanks. Dieter
614 Mar 2011 @ 04:51 PDTApplicationsUsing Teradata Query Banding to handle Security ViewsHi Phil, there's only one drawback: getQueryBandValue is evaluated once per row, thus increasing CPU usage. It's currently defined as NOT DETERMINISTIC, but can be changed to DETERMINISTIC withou...
511 Mar 2011 @ 08:17 PSTMarcio MouraWhen is the right time to refresh statistics? - Part IITD12.0.3.1/TD13.0.0.21 introduced a new version 4 for the binary statistics. You'll find the latest version of my stats query (which those calculations are based on) at http://www.teradataforum....
410 Mar 2011 @ 01:51 PSTDatabaseWhat you need to know before creating a table in TeradataThe main difference between SET/MULTISET tables can be noticed when there's INSERT VALUES vs. INSERT SELECT: INSERT VALUES never silently discards duplicate rows, but INSERT SELECT will if the ta...
315 Feb 2011 @ 01:48 PSTRobG's blogUsing INTERVAL to Add or Subtract Fractional Seconds to or from TIMESTAMP ValuesHi Rob/crowley, this truncation (based on applying a FLOOR to the result of a TimeStamp/Interval calculationis) is required according to Standard SQL, so Teradata is just following SQL:2008 rules....
214 Feb 2011 @ 04:21 PSTRobG's blogDetecting a Broken Prior Value/New Value ChainHi Rob, two parts where this can be further simpliyfied: #1: Do the same RANK-calculation in both Derived Tables and then join on "o.Rnk = n.Rnk - 1". Then the optimizer will re-use the spoo...
122 Nov 2009 @ 05:04 PSTDatabaseRemoving Multi-Column Statistics – A Process for Identification of Redundant StatisticsHi Dave, good article, this triggers some possible enhancements to my stats query :-) Hmmm, where's that "FieldCount" column in HELP STATS COLUMN calculated from? A new column comparing the nu...

Pages