#DateWhereItemComment
920 Dec 2013 @ 12:48 PSTcarrie's blogStatistics collection recommendations – Teradata 14.0Hi Carrie, In TD 13.10 and older, when collecting on multiple columns, the order of the columns in which the optimizer analyzed the demographics was determine not by the order of the collect state...
802 Dec 2011 @ 10:37 PSTÜber SQLGlobal and session level parameters in SQLThat is the same behavior that I experienced! The GetQueryBandValueSP also seems to return the correct value. Can you give me a good explanation of what deterministic and not deterministic actual...
702 Dec 2011 @ 08:50 PSTÜber SQLGlobal and session level parameters in SQLThanks deiter! This is really interesting now... I decided to replace the getquerybandvalue as 'NOT DETERMINISTIC' instead of 'DETERMINISTIC'. Believe it or not, this eliminated the behavior d...
601 Dec 2011 @ 03:09 PSTÜber SQLGlobal and session level parameters in SQLWhen I execute a view with a function it appears as though the view results get cached and do not change unless(1) a certain amount of time passes, or (2) the view gets replaced. I am executing th...
530 Nov 2011 @ 07:37 PSTÜber SQLGlobal and session level parameters in SQLPerfect... just what I was looking for.... Thanks! I'm in the process of developing a row and column level security scheme in our EDW. I believe I am going down the path of creating a security ...
429 Nov 2011 @ 06:43 PSTÜber SQLGlobal and session level parameters in SQLHi Deiter, I replaced GetQueryBandValue as deterministic and then ran the following: SET QUERY_BAND = 'dbname=dbc;MyDate=2011-03-01;' UPDATE FOR SESSION; explain SELECT * FROM dbc.Datab...
309 Jun 2011 @ 07:18 PDTViewpointTeradata Manager - Where is that in Viewpoint?I schedule and run many DBA related bteq scripts on the TD MGR box. Is there currently a scheduling feature like this in ViewPoint? If not, do you have any recommendations on how to replace this ...
208 Sep 2010 @ 07:59 PDTDatabaseWorkload Toolkit – Part 4 – Compression AnalysisI agree JK... I just bought CompressTool (along with SyncTool) a couple of weeks ago and love it. My only point was that to justify the cost, even though we know it saves money, to upper managemen...
108 Sep 2010 @ 05:32 PDTDatabaseWorkload Toolkit – Part 4 – Compression AnalysisAtanaSoft has a pretty good tool called CompressTool (there is a pretty hefty price tag with it though). Deiter also has a pretty good compression algorithm that I have used quite a bit in the pas...