All forum activity

#DateUserForumTypeThreadPost
114216 Jun 2006 @ 12:17 PDTgiriAnalyticsTopicsql in cachehai can anyone give clarification on marked queries. what are they and how are they created. how long they remain in the cache.thank you
114116 Jun 2006 @ 12:16 PDTgiriDatabaseTopicsql in cachehai can anyone give clarification on marked queries. what are they and how are they created. how long they remain in the cache.thank you
114016 Jun 2006 @ 12:12 PDTgiriUDATopicperformance issue SELECT * FROM TABLENAME; ANDSELECT * FROM TABLENAME WHERE 1=1;WILL THERE BE ANY PERFORMANCE DIFFERENCE;AND ALSOWHAT WILL BE THE PERFORMANCE ISSUE WITH MULTI STATEMENT REQUEST?WITH AN EXAMPLE PLEAS...
113915 Jun 2006 @ 06:42 PDTgiriToolsTopicPERFORMANCE ISSUESELECT * FROM TABLENAME; ANDSELECT * FROM TABLENAME WHERE 1=1;WILL THERE BE ANY PERFORMANCE DIFFERENCE;AND ALSOWHAT WILL BE THE PERFORMANCE ISSUE WITH MULTI STATEMENT REQUEST?WITH AN EXAMPLE PLEASE.
113815 Jun 2006 @ 06:40 PDTgiriAnalyticsTopicPERFORMANCE ISSUESSELECT * FROM TABLENAME; ANDSELECT * FROM TABLENAME WHERE 1=1;WILL THERE BE ANY PERFORMANCE DIFFERENCE;AND ALSOWHAT WILL BE THE PERFORMANCE ISSUE WITH MULTI STATEMENT REQUEST?WITH AN EXAMPLE PLEASE.
113715 Jun 2006 @ 03:00 PDTak_tdataToolsTopicTrack NUSI UsageIs there a way to track a NUSI usage or last time when the index was last used?
113614 Jun 2006 @ 03:31 PDTmaheshalwaysDatabaseTopicRetaining 1 random record among many duplicatesI wanted a query to delete duplicate (retain ANY 1 row) in Teradata table, without creating any volatile table or complex logic. Wanted your inputs in this regard. In oracle we can do this with “...
113514 Jun 2006 @ 02:39 PDTVincent GabrielliToolsTopicTeradata Query SchedulerScheduling Queries for Later Execution Requests issued by Teradata SQL Assistant where can I get a copy of Teradata Query Scheduler ? is it free?can someone provide a copy or link
113414 Jun 2006 @ 02:35 PDTBwillyJobsTopic4 Teradata DBA Positions - New York CityTeradata DBA (2 Full-Time AND 2 Consultant Positions)Large New York City Company is looking for a DBA with 3-5 years experience in Teradata and Oracle 8/ 9i. Will train in Oracle. Needs to have exp...
113314 Jun 2006 @ 10:16 PDTIsabelle SalmonDatabaseTopicUDFs : Use of DECIMAL8Hallo, I'am trying to use the data type DECIMAL8 as input parameter in for an UDF.In the BTEQ script :CREATE FUNCTION udf_to_char(InputNumber DECIMAL(18,8))... is OKIn the C script :void udf_to_cha...
113214 Jun 2006 @ 10:08 PDTTony-2824ToolsTopicRights and UsersHi!I would like to know how to list all the users and their rights (with sql assistant for example) when you are connected to a data source. Is there any query which is able to get all the roles (g...
113114 Jun 2006 @ 08:11 PDTRob88UDATopicData Structure presented to Reporting ToolI'm new to Teradata, so forgive me if this is an obvious question.In all docuemntaton I can find about Active Datawarehousing in Teradata it states that the data is stored in TNF.Is this the format...
113014 Jun 2006 @ 03:40 PDTTDUser-781DatabaseReplyNew to teradataHi,yes you can installa Teradata on your Windows computer.I don't know if you can donwnload the demo version from one Teradata website, but you can ask for the free demo cd. It will be sent to you ...
112913 Jun 2006 @ 09:08 PDTterausrDatabaseTopicConditional Duplicatesdeleted
112813 Jun 2006 @ 05:23 PDTilyasDatabaseTopicNew to teradataI want to learn teradta. Can I install teradata on Windows? If yes, can I download evaluation version of teradata for education purposes, like we can download oracle fom otn (Oracle technology netw...
112713 Jun 2006 @ 06:30 PDTstami27-2406ConnectivityTopicEfficiency UDF scalar function vs.conventional SQLTo test an attribute in numeric I can use the function is_integer from Mr. Dennis Calkins (Thanks here for Mr. Calkins) athttp://www.teradataforum.com/is_integer.htmThat is a very smart and concis...
112613 Jun 2006 @ 04:25 PDTTDUser-781TrainingReplyTeradata Design ArchitectHi,the exam you are interested in is based on the same topics of the phisycal implementation one, but it requires a deeper knowledge of these topics.Take a look at http://www.teradata.ncr-education...
112513 Jun 2006 @ 12:49 PDTj355gaTrainingReplywhat is wrong with prometric?I contacted the Teradata certification group regarding Prometric's web-site. Teradata informed me that Prometric is attempting to fix the web-site. I have not tried since last week so I don't kno...
112412 Jun 2006 @ 10:39 PDTnithyanandamTrainingTopicTeradata Design ArchitectCan any one who has given this exam, tell me the topics/pdf's for the above exam?Thanks
112312 Jun 2006 @ 10:26 PDTnithyanandamTrainingReplywhat is wrong with prometric?Yes. I experienced as well. I did complain about the web site, when I called them up last week. Not sure, whether they have rectified that.
112212 Jun 2006 @ 10:24 PDTnithyanandamTrainingReplyNR0-012 Physical Implementation ExamPreetiSQL Reference Vol II and Teradata RDBMS - Database Design are two important documents, from which you can prepare for the PI exam.CheersNithyanandam.
112112 Jun 2006 @ 10:27 PDTTD_ArchDatabaseReplyMigrating to V2R6Yes, Installing TTU8 is must.
112012 Jun 2006 @ 10:08 PDTTD_ArchDatabaseReplyQuestion Regarding from sub tables?Yes, sub tables are used by the Optimizer/Hashing algorithm to reach the actual base tables, but a user cannot auery a sub table directly.
111912 Jun 2006 @ 09:05 PDTwilliamdieterDatabaseReplyODBC Driver changing submitted SQLWe got it to work, that's no biggie. I'm just trying to figure out why we were getting these results in case there was a bug. It looks like it's not Teradata that's doing it. If I execute the query...
111812 Jun 2006 @ 09:04 PDTwilliamdieterDatabaseReplyODBC Driver changing submitted SQLWe got it to work, that's no biggie. I'm just trying to figure out why we were getting these results in case there was a bug. It looks like it's not Teradata that's doing it. If I execute the query...

Pages