#DateWhereItemComment
526 Apr 2012 @ 05:39 PDTDatabaseSay Yes to No Primary Index (No PI) TablesIs there a way defined to understand the effectivity of NOPI compared to PI tables. I tried to comapre CPU, IO, Spool Usage from dbql tables. It provided a very less difference in cpu, IO used ...
426 Apr 2012 @ 05:34 PDTcarrie's blogTeradata 13.10 Statistics Collection Recommendations You should also consider the CPU taken by collect stats operation. You should practice stats collection on a basis of % change of data. I say a minimum of 10% of data load should be happenin...
327 Oct 2011 @ 07:53 PDTRaising IntelligenceViewpoint support for Teradata DB authentication strategiesHi Gryback I used to run bteq scripts while inserting in to dbcmngr.alertrequest with actioncode set to 'T' and it executes the script which is stored in path C:\Program Files\NCR\Teradata Manag...
225 May 2011 @ 08:05 PDTcarrie's blogHow to Calculate Your Max Number of Usable AMP Worker TasksHi Carie IN TD Manager, I always see 49 AWTs for my linux 5550 box. Is there a change in Linux nodes? Thanks -Rajni
124 May 2011 @ 02:43 PDTRobG's blogDetermining Month-End Date for a Date DimensionThis is because of TD date storage as integer internally. Here is how you can see sel cast(date as int);