All comment activity

#DateUserWhereItemComment
507702 Sep 2014 @ 09:04 PDTsuhailmemon84Paul Sinclair's Blog on PartitioningTD 14.0 - The other partitioning enhancementsThanks Paul.
507602 Sep 2014 @ 05:10 PDTpietro.nardellacarrie's blogNew opportunities for statistics collection in Teradata 14.0Ciao Carrie, I have a very simple and quick question regarding STATS and CURRENT STATS. I create a table T and define some stats without insert any rows. If I run      HELP ...
507502 Sep 2014 @ 03:10 PDTlzapataToolsTeradata Studio Express 15.00 now availableHello; I am going through several troubles with Parameters in the Sql Editor: 1) Although I use "named parameters" and I reuse the same parameter in several places of a query, the dialo...
507402 Sep 2014 @ 02:49 PDTlzapataToolsTeradata Studio Express 15.00 now availableHi Francine, I have found an issue in this release 15.00 which didn't happen in previous ones. When I drag a list of columns in a table from the "Data Source Explorer" tree to t...
507330 Aug 2014 @ 03:28 PDTPaulSinclairPaul Sinclair's Blog on PartitioningTD 14.0 - The other partitioning enhancementsI wish I could provide such information but until there is an officical announcement of a release and its content and since release content is subject to change, I am unable to provide th...
507229 Aug 2014 @ 11:45 PDTProactiveViewpointKiller queries: Track them, find them, fix themThanks Shrity so much. Would u plz tell me what is requests (count) in Session Info in query monitor overview tab. Is it also related to slowness issue? Means culprit queries can have high request...
507129 Aug 2014 @ 04:50 PDTcarriecarrie's blogNew opportunities for statistics collection in Teradata 14.0Srini,   My apologies, but I did not get notified of your comment.   The asterisk in the first line of the HELP STATS output represents the row count of the table.  It comes from...
507029 Aug 2014 @ 04:42 PDTcarriecarrie's blogStatistics collection recommendations – Teradata 14.0Chetan,   The first line that you see in the HELP STATS output in 14.0 represents the table row count in the UniqueValues column.   That is why it has an asterisk for the Column Na...
506929 Aug 2014 @ 04:34 PDTcarriecarrie's blogWorkload Management with User Defined Functions and Table OperatorsGeeta,   There are many different delay queues in the database.   When you say "delayed sessions in the delay queue" that you say you can see in Viewpoint, I believe you ...
506829 Aug 2014 @ 09:50 PDTsuhailmemon84Paul Sinclair's Blog on PartitioningTD 14.0 - The other partitioning enhancementsThanks Paul. Do you know which future release will allow treating CURRENT_TIMESTAMP as constant and facilitate creation of a specific plan?
506729 Aug 2014 @ 08:58 PDTsmazingoDatabaseTeradata Express 14.0 for Amazon EC2 Configuration Guidetry the reboot. perhaps the volumes did not complete the attach. i've seen this before as well and the reboot worked. steve
506627 Aug 2014 @ 07:20 PDTgeethareddycarrie's blogWorkload Management with User Defined Functions and Table Operatorshi Carrie, While reading this article, few things triggered me to get clarified on 'delay issues on the system'. Sometimes we see too many delayed sessions in delay queue from Viewpoin...
506527 Aug 2014 @ 12:00 PDTAsim NaveedToolsCreating a Simple Java User Defined Function using the Teradata Plug-in for Eclipse I have following java UDF which i'm calling from external stored procedure. Issue is when an SQLException occurs i get truncated error message in Parent SP Exit handler MESSAGE_TEXT of GE...
506426 Aug 2014 @ 11:49 PDTfgrimmerToolsTeradata Studio Express 14.10.01 now availableSaran, Which OS version are you trying to install? If Windows or Linux, are you installing 32-bit or 64-bit?
506326 Aug 2014 @ 11:47 PDTsrsaranToolsTeradata Studio Express 14.10.01 now availableUnable to install Studio. Same error "Unable to find the Jave runtime environment". Have updated the path, the path shows correct, but the installer can not see the jave JRE.
506226 Aug 2014 @ 08:23 PDTfgrimmerToolsTeradata Studio Express 15.00 now availableClaus, If you are having a delay when typing in SQL Editor, you can try turning off code assist. Go to the Tools menu and untoggle the Code Assist Autoactivation option. Code assist is gathering in...
506126 Aug 2014 @ 05:19 PDTclaush@netflix.comToolsTeradata Studio Express 15.00 now availableHi Francine, I just upgraded to Studio Express 15 and it seems more than half the time a few minutes after starting, typing in the SQL editor feels like it's on time delay. It's almost unus...
506026 Aug 2014 @ 02:49 PDTLUCASViewpointTeradata Viewpoint 15.00 Release ArticleHo yes ! it would be very very helpful, avoiding to ramble through windows to retrieve roles and portlets and permissions ... Pierre
505925 Aug 2014 @ 10:47 PDTTera_LokDatabaseTeradata Express 15 for VMware Player Available NowHi Everyone,   I have dowloaded and Installed Teradata Express TTU 15.0.0 Version client tools fir Windows 8. Could any help me to get VM player with SUSE or LINUX configured with Teradata d...
505825 Aug 2014 @ 03:10 PDTPaulSinclairPaul Sinclair's Blog on PartitioningTD 14.0 - The other partitioning enhancementsTimestamp partitioning works with nonequality conditions in 14.0 with constants but not with CURRENT_TIMESTAMP. Prior to Teradaata 12.0, this was also true for date partitioning and the CURRENT_DAT...
505725 Aug 2014 @ 08:34 PDTGDHARViewpointTeradata Data Lab and Viewpoint 14.0 releasesThanks Gary!
505625 Aug 2014 @ 08:30 PDTprabha.m17@gmail.comToolsUsing Teradata PT To copy from other databasesNice article.. can I use Tpt to transfer data from teradata to Oracle?
505525 Aug 2014 @ 08:00 PDTgrybackViewpointTeradata Data Lab and Viewpoint 14.0 releasesI don't see anything related to this in any patch descriptions. As such, I'd recommend filing a Teradata services support incident for further analysis and resolution.
505425 Aug 2014 @ 03:50 PDTGDHARViewpointTeradata Data Lab and Viewpoint 14.0 releasesHi Gary, Thanks for the quick responce. Yes, i have deleted the Lab Group through the Lab Group Setup portlet only. Presently we are useing Data Lab 14.10 and TD 13.10.07 version. Thanks in advan...
505324 Aug 2014 @ 09:29 PDTsuhailmemon84Paul Sinclair's Blog on PartitioningTD 14.0 - The other partitioning enhancementsHi Paul, Does timestamp partitioning in TD 14.0 work only in equality conditions? I tried the following example and i could not achieve partition elimintation when a <= or >= was used. &nbs...

Pages