#DateForumTypeThreadPost
4116 Sep 2010 @ 11:07 PDTDatabaseReplyoptimize select top10 * from table1 &&compare&& select * from table1Top without order by is non-deterministic Any N. Any N optimization is in Teradata 13.0. You are probably on pre-13.0 database. You can rewrite as select * from table1 sample 10; or use r...
4016 Jul 2010 @ 07:48 PDTCloud ComputingReplyTeradata Express 12 for Amazon EC2 available?We have updated the AMI instances to new efix packages, so id have changed to: b508e1dc for 13.0. If you don't have access to it shoot me an email. I will update all the articles with latest ...
3906 May 2010 @ 11:44 PDTDatabaseReplyDevising a comprehensive process for "Collect Stats" on the entire EDWYou can use Statistics Wizard product, specify a workload, or a database, or a selection of tables, it will give you recommendations from which you can then take action.
3813 Apr 2010 @ 08:43 PDTDatabaseReplyDoes Teradata restart after a node reboot?are the devices ready when system reboots and TD starts up?
3711 Apr 2010 @ 08:17 PDTDatabaseReplyHow to automate commands?It is doable. You can use cnsrun to run vprocmanager in CNS and automate the steps. cnsrun [ -machine ] [ -help ] { -utility | -join | -query } [ -screen ] [...
3601 Apr 2010 @ 08:17 PDTTrainingReplyTeradata Training - Bangalore@gkippili, knowledge and job prospect are two separate things. In general, the more a person do to improve him/herself, eventually it will pay off, but how soon that happens has more to do with lu...
3526 Mar 2010 @ 08:22 PDTCloud ComputingReplyHow to get ZMD client running in TD13 1TB VMWare version?check your nameserver setting in /etc/resolv.conf and make sure it is correct within your network
3426 Mar 2010 @ 08:12 PDTDatabaseReplyTD 13@Random_Thought, I managed the database side of the TVS development program and took it to the start of beta prior to moving to China. Since it has been 1+ year away from the program, I am not the...
3325 Mar 2010 @ 11:22 PDTDatabaseReplyTD 13Teradata Virtual Storage
3224 Mar 2010 @ 10:07 PDTUDAReplyTeradata - Oracle - Query Rewrite - Qualify & RankQualify ( ) allows filtering and basically behaves like a having clause with order descending in its default syntax. Assuming frm_dt is a date, looks like your query is simply getting the latest e...
3110 Mar 2010 @ 04:30 PSTCloud ComputingReplyIs there any way to control the size of the virtual machine for my small laptop disk?also, you can define an user with a maximum perm space to sort of set a maximum and load data under that user.
3009 Mar 2010 @ 11:38 PSTCloud ComputingReplyIs there any way to control the size of the virtual machine for my small laptop disk?the pdisks don't shrink because they are raw partitions. by deleting unused data, you can make sure it is not bigger than already is. there is no perfect way. OS drives can be shrinked.
2908 Mar 2010 @ 06:36 PSTCloud ComputingReplyIs there any way to control the size of the virtual machine for my small laptop disk?Generally we haven't seen the vm virtual disk's physical size on disks growing much more than the amount of data you have loaded into database. My advice is to 1. periodically check the total pe...
2805 Mar 2010 @ 01:41 PSTGeneralReplyTeradata and Chinese Languagesomehow there's an extra space in the link, remove the %20 in the link will do it.
2703 Mar 2010 @ 09:11 PSTGeneralReplyTeradata and Chinese Languageyou need unicode encoding, see http://developer.teradata.com/connectivity/articles/invoking-workstation-bteq-to-use-unicode
2603 Mar 2010 @ 03:24 PSTTrainingReplyWant Teradata SQL Tutorialpayalatul, unfortunately V2R5 exams don't carry over to 12.0 exams, which means that you are either a V2R5 master or you have to start-over again. So I'd suggest take 12.0 exams instead.
2501 Mar 2010 @ 12:29 PSTDatabaseReplythe clutter with explains .Just what is it and how to avoid that : Redistribution and DuplicationUse Visual Explain or Query Analysis Facility (QAF). Redistribution happens when your query is joining tables on non-primary index columns. You may want to rewrite your queries so that you join o...
2424 Feb 2010 @ 09:35 PSTDatabaseReplyOptimizer expert, please correct my under standing herewell, if it is a bug please either open an incident or give us sufficient information so we can get the bug fixed. thanks
2324 Feb 2010 @ 04:53 PSTToolsReplyBuilding excel sheet from bteq Export having more then 65K rowsyou can write the data into Excel XML format, which supports multi-sheet, convert the following simple program at below link into perl should be a trivial matter. http://www.codeproject.com/KB/a...
2223 Feb 2010 @ 11:05 PSTToolsReplyBuilding excel sheet from bteq Export having more then 65K rowsnot sure if TPT has that functionality, but here is a way to split then get into excel as multiple spreadsheet http://bytes.com/topic/visual-basic-net/answers/605945-split-large-text-file-number...
2123 Feb 2010 @ 06:07 PSTToolsReplyBuilding excel sheet from bteq Export having more then 65K rowsTPT (Teradata Parallel Transporter) can do the export to csv for you, much easier than using bteq or fastexport, etc.
2019 Feb 2010 @ 11:33 PSTCloud ComputingReplyTeradata Express 12 for Amazon EC2 available?send to nick.xie@teradata.com
1919 Feb 2010 @ 01:57 PSTCloud ComputingReplyTeradata Express 12 for Amazon EC2 available?send an private message to me with your email address.
1817 Feb 2010 @ 03:20 PSTCloud ComputingReplyCloud Slam Event - CS '10 virtual Cloud Computing conferenceit is interesting, i will forward to some folks
1715 Feb 2010 @ 02:21 PSTCloud ComputingReplySUSE VMware image of TD13 Express dies intermittentlyNot having more information available, it is hard to tell what is going on. However, there's a few small tricks to clean up the vmware images 1. shut down vm instance, go to the folder where th...

Pages