#DateWhereItemComment
2526 Aug 2015 @ 11:36 PDTToolsTransitioning from SQL Assistant to Studio ExpressThanks Francine. What are tentitive release dates for Studio 15.11 ?
2426 Aug 2015 @ 10:14 PDTToolsTransitioning from SQL Assistant to Studio ExpressYes, one of analytics manager requirement is to allow only limited set of rows to a certain business group. I also tried TASM but it is dependent on explain estimates which can vary due to multiple...
2325 Aug 2015 @ 11:41 PDTToolsTransitioning from SQL Assistant to Studio ExpressVery infomative arcticle .Thanks for sharing. One question for you Is there any way to control - Max Display Row Count on users machine? Scenerio is that I want only 2000 rows to dispaly for all a...
2230 Apr 2015 @ 10:20 PDTDatabaseIdentifying Used, Unused and Missing Statisticsthanks for the explanation.
2129 Apr 2015 @ 11:26 PDTDatabaseIdentifying Used, Unused and Missing StatisticsThanks RK. I see similarity in capturing the logging on objects and user from existing access logging feature.How about comparing new feature against existing access logging ? I understand sta...
2023 Apr 2015 @ 04:07 PDTDatabaseIdentifying Used, Unused and Missing StatisticsThanks for the info.  Very quickly , can you point out the difference between this new feature and existing logging of DBQLObjTbl ?  
1926 Feb 2014 @ 04:26 PSTMarcio MouraLet's talk about Stored ProceduresI dont think anybody can help with such request. Better to read the manuals and learn to resolve syntax error.
1831 Oct 2011 @ 07:55 PDTToolsAdvanced Concept for Workload Analyzer (TWA) - Workload Drill-Down Thanks again Birendra. I was able to generate Candidate Workload Report after installing TWA 13.10 Excited to try your recommendations !!
1730 Oct 2011 @ 04:27 PDTToolsAdvanced Concept for Workload Analyzer (TWA) - Workload Drill-Down Lots of information listed here Birendra. Many thanks for sharing. While following the given example , for STEP 1 , in TWA -> Analysis-> New Workload Recommendations , I chose DBQL and gave a sta...
1607 Sep 2011 @ 05:00 PDTTeradata Performance ConsiderationsPerformance Data Collection Recommendations for Major UpgradesHello Woody You wrote: " When using threshold logging, you can never log to the other tables. Therefore, you cannot capture full SQL, the explain or object data" Understanding that article ...
1523 Feb 2011 @ 03:07 PSTToolsHow many digits in a DECIMAL?Thanks for the post. A general question - Can you highlight increase in maximum decimal digits for each Teradata release?
1404 Aug 2010 @ 05:51 PDTTeradata Performance ConsiderationsHow do you create those cool ResusageSPMA (Higa) charts?This time around , i tried with Excel 2003 and it worked.....many thanks for the post and suggestion...
1302 Aug 2010 @ 02:56 PDTTeradata Performance ConsiderationsHow do you create those cool ResusageSPMA (Higa) charts?I tried , saved pma.out file , enabled macro while opening excel and clicked on start. It resulted in opening of MS Visual Basic with a pop up error (Compile error:Named argument not found)with a ...
1209 Jul 2010 @ 02:02 PDTDatabaseWorkload Toolkit - Part 3 - Statistics AnalysisHi David - Where to locate Table/view - TOOLSDB.Stats_Info_64bit ?
1109 Jul 2010 @ 12:24 PDTToolsWhat's new in Teradata SQL Assistant 13.10Mike , Having seen SQL Assistant improving with each release is a satisfying experience.Considering your expertise with TD tools and utilities , I wanted to reach to you to log few issues with c...
1014 May 2010 @ 12:17 PDTMarcio MouraLet's talk about Stored ProceduresLot of learning from your blog !! Would like to request you to touch the sensitive area of SPs inablities in utilising Teradata parallelism. Has things changed with TD 12 ..TD 13? Do you recomman...
904 Feb 2010 @ 10:39 PSTToolsTeradata Utility Error Handling - FastloadJust a clarification - You mentioned- Restart after client failure- is it same as restartablity caused by database/script issues such as script failing due to data formatting,invalid TIMESTAMP and ...
801 Feb 2010 @ 12:55 PSTDatabaseRemoving Multi-Column Statistics – A Process for Identification of Redundant StatisticsVery useful information on Stats. Does that mean that if a PI/UPI is having X unique value and PI/UPI + MVC is also having identical value of X , then MVC can be taken off ? Irrespective of 16 byt...
701 Feb 2010 @ 10:19 PSTTeradata Performance ConsiderationsMemory on Linux Teradata Systems - How do I know if I have a problem?Informative article for sure. Talking about Larry Higa's chart, can you detailed about the abc of the it?It will be very beneficial for anyone wanting to know more about monitoring/system performan...
612 Nov 2009 @ 10:14 PSTcarrie's blogControlling the Flow of Work in TeradataNice article indeed... to add further , alerts for AMP Worker Tasks generates from TDManager , eg - Threshold Value: 5 Actual Value: 2 Meaning that the lowest threshold value for an AMP is 5 ...
510 Nov 2009 @ 11:47 PSTDatabaseCan We Speak Confidentially? Exposing Explain Confidence Levels Many thanks for the direction...
407 Nov 2009 @ 11:02 PSTDatabaseCan We Speak Confidentially? Exposing Explain Confidence Levels Dear Carrie Allow me to be bit selfish in asking you an off-the-track but a related question. While collecting statistics on a table,I got "out of spool space " error,so much so that it resul...
306 Nov 2009 @ 02:35 PSTcarrie's blogWhen Your Dirty Read is Kept WaitingHello Carrie While reading above article, I need one clarification. You mentioned - " When dropping partitions, if NUSIs or join indexes are present, it is recommended that the rows be dele...
206 Nov 2009 @ 01:06 PSTDatabaseWorkload Toolkit Part I – Excessive use of String Manipulation VerbsVery good article indeed....it hits at the right areas. Talking of performance analysis can I request you to pen down important steps to observe performance issues. At our site, we had a performan...
108 Oct 2009 @ 04:32 PDTDatabaseStatistics Collection Recommendations for Teradata 12Hello Carrie... I'm a big fan of your postings.Nice to find you here.It will surely bring quality to the forum. I have a basic question- Which table columns can go without the need of collectin...