#DateForumTypeThreadPost
12805 Sep 2011 @ 10:06 PDTJobsTopicTeradata DBA with good knowledge of ETL and shell scripts Hi All, I am looking for a Teradata DBA with good knowledge of ETL and shell scripts in offshore location (India ) who can join immediately . Good referral money. Send cv to teradata1972...
12724 Sep 2010 @ 05:43 PDTJobsReplyTRM 6 Implementation SydneyLet me know your email to send details
12608 Sep 2009 @ 08:53 PDTDatabaseTopicTeradata Version Upgrade to V2R12Hi All,We are currently on V2R6.2 , 64 bit SUSE and plan to upgrade to V2R12 Please share your experience with upgrade to V2R12 like how much time it took and what all precautions were taken or sen...
12524 Mar 2009 @ 12:46 PDTDatabaseReplyJournal Restore Error *** Failure 2852:request your replies
12418 Mar 2009 @ 05:27 PDTToolsTopicjournal restore Error :*** Failure 2852Trying to restore journal from backup but restore fails with following error*** Failure 2852:Inconsistent check point records found on Restored journal. Request you to share your thoughts or did ev...
12318 Mar 2009 @ 05:26 PDTDatabaseTopicJournal Restore Error *** Failure 2852:Trying to restore journal from backup but restore fails with following error*** Failure 2852:Inconsistent check point records found on Restored journal. ...
12228 Feb 2009 @ 10:58 PSTJobsReplyWe can Help you in gettng JOB in Teradataterahyderbad@gmail.com :Please correct your posting specific to race , this is not a local posting and is read worldwide ;
12116 Jan 2009 @ 08:13 PSTDatabaseTopicsum part of sql takes a lot longer timeHi,this is a sql tuning question ,I have a sql which does the sum but the sum step takes a lot of time can you let me know how to tune so that teradata quickly perform sum part thanks
12018 Dec 2008 @ 12:19 PSTDatabaseTopicExplain Plan : 1=1 join meaningHi,I have seen explain plain where join of 1=1 is mentioned can you tell what it means
11904 Dec 2008 @ 06:36 PSTDatabaseTopicParsing and CPU skewI have situations where during parsing CPU and Disk skew is 90% or more ,did anyone foundthis or it's a problem at my end only
11801 Dec 2008 @ 09:55 PSTToolsTopicTDWM QuestionHi All,I have created two Workloads (WD) and also activated them but on checking only WD-Default is active or operating on the userids on which I have create WD request your answers Thanks
11715 Aug 2008 @ 03:53 PDTDatabaseReplyHow to convert minutes to H:M:S formatsorry e.g. is select cast(interval A minute AS interval hour to second) FROM TAB1;
11615 Aug 2008 @ 03:52 PDTDatabaseReplyHow to convert minutes to H:M:S formatThanks for reply , This interval '312' canbe a column from table e.g. select cast(interval A minute AS interval hour to second);but I got syntax error .
11514 Aug 2008 @ 04:39 PDTDatabaseReplyHow to convert minutes to H:M:S formatHi,What I am trying to achieve is like 312 minutes if converted will be like 05:12:00 (HMS) format
11413 Aug 2008 @ 07:03 PDTDatabaseTopicHow to convert minutes to H:M:S formatHi all,is there any inbuilt function to convert minutes to H:M:S format in SQL Thanks
11322 Jul 2008 @ 10:26 PDTDatabaseTopichow to find out accesslog on user enabledHi,is there any sql by which accesslog on user enabled can be found out
11208 Jul 2008 @ 10:25 PDTDatabaseTopicHow to clear the buffer for testing sql performanceHi ,is there any command in Teradata which clears the buffer so that the sql performance can tested properly I remembered something to do with diagnostic ,Thanks in advance
11103 Jun 2008 @ 01:34 PDTDatabaseReplyCase in SELECTThanks for reply ,it is now using index , but if I cover it up with another select layer then it doesn't e.g.Select * from (Select CASEWHEN SUBSTR(TRN_NM,13,1) = ' ' THEN TRN_NM ELSE SUBSTR(TRN_NM...
11002 Jun 2008 @ 02:35 PDTDatabaseReplyCase in SELECThere is the sql Select CASE WHEN SUBSTR(TRN_NM,13,1) = ' ' THEN TRN_NM ELSE SUBSTR(TRN_NM,1,6)...
10930 May 2008 @ 01:40 PDTDatabaseTopicCase in SELECTHi,I have a query which uses CASE on the a indexed column, the bad part is it ignores the index ,is there any way I can force index on it Thanks
10823 May 2008 @ 02:14 PDTDatabaseReplymulti partititon optionany replies
10721 May 2008 @ 01:44 PDTDatabaseTopicmulti partititon optionHiwhat are the advantages of doing multi partititon any good real examples will be of great help Thanks
10606 May 2008 @ 01:56 PDTDatabaseReplyHow to Stop ransient Journal?requesting resplies
10506 May 2008 @ 01:56 PDTToolsReplyTransient Journalrequest your replies
10405 May 2008 @ 12:45 PDTToolsTopicTransient Journalis there any database parameter which can stop automatic transient journal in version V2R6.2

Pages