#DateForumTypeThreadPost
15914 Nov 2014 @ 10:15 PSTTeradata StudioReplyFeature RequestsThank you for the update! Hopefully you can remediate the JDBC driver issue soon.
15814 Nov 2014 @ 09:16 PSTTeradata StudioTopicFeature Requests Teradata Studio doesn't display total row in row limit dialog There isn't a setting or preference in Teradata Studio that will allow the user to display the total number of rows t...
15728 May 2014 @ 06:50 PDTDatabaseReplyDBQL AMPCPUTime and TDWM Exception AbortIn Teradata 13.10 (and as recent at TD 14) I believe the DBQL AMPCPUTime reported for queries that are aborted (TDWM exception or other errors) is typically what has been consumed prior to the step...
15628 May 2014 @ 06:40 PDTDatabaseReplyBest practise table creation with primary key or/and index?At a very high level, logical primary keys can be enforced with a unique secondary index (USI)  allowing the table's primary index to be defined to provide the best data distribution, data...
15508 Oct 2012 @ 10:08 PDTDatabaseReplypartition questionWhat do your table statistics look like?   Generally an inequality condition is going to result in a FTS.
15405 Oct 2012 @ 05:12 PDTDatabaseReplySQL to find Row CountLearned something new! Thanks Dieter. Didn't even consider StepInfo. Step Info does generate a significant volume so from a historical basis you'd want to keep 30-60 days tops and maybe bu...
15304 Oct 2012 @ 06:41 PDTDatabaseReplySQL to find Row CountNo. DBQL doesn't seem to log records inserted, deleted, or updated by INSERT, UPDATE, DELETE, or MERGE operations. Do you have any timestamp or date fields on the table to track when records h...
15204 Oct 2012 @ 10:36 PDTGeneralReplyWish list for forum developmentIs the goal of the forums here to be more Q&A and less conversational? If so then I would suggest visiting StackOverflow and other StackExchange related sites. I believe there is a lot that cou...
15103 Aug 2012 @ 02:39 PDTToolsReplyAlter table to add column after specific column ALTER TABLE will place any new columns at the end of the table definition. To place this column in the ordinal position on the table you will need to create a new table with the column in the pr...
15002 Aug 2012 @ 09:11 PDTViewpointTopicQuery Pinspot: Query Spotlight + Query Group Functionality Query Groups are great for allowing BI Tool admins to monitor tool specific sessions that are currently active and rewind to go back in time. However, Query Spotlight is a great tool to spotligh...
14901 Aug 2012 @ 05:23 PDTGeneralReplyPDCR tables CleanUp Where are your maintenance routines for PDCR installed to migrate data from the DBC tables to PDCRData? This is where you should also find the script(s) for maintaining the PDCRData tables. ...
14814 Feb 2012 @ 05:44 PSTToolsReplyTTU for Linux I don't believe that TTU 13.10 for SuSE Linux is available to download in the public domain. You may need to work with your Teradata CSR to obtain the software or via Teradata @ Your Service.
14713 Feb 2012 @ 09:10 PSTDatabaseReplyPerformace of Count(Distinct) Couple of thoughts come to mind: AJI would be one option, as mentioned, depending on your load strategy for the tables. Some load utilities require that AJIs be dropped and recreated aft...
14608 Feb 2012 @ 12:22 PSTToolsReplyBest Memory specification for SQL Assistant V13 Which version on SQL Assistant are you using? SQL Assistant should not cause your computer to become unresponsive for the duration of the query. If your computer is becoming unresponsive whi...
14507 Feb 2012 @ 08:58 PSTGeneralReplynext levels in a DW career Are you looking to continue your career as a developer or transition into something like an architect/data modeler or a database administrator?
14407 Feb 2012 @ 08:54 PSTToolsReplyText Qualifiers in Teradata Utilities   I'm afraid up to TTU 13.10 it's not possible. You could try to write an INMOD to address the text qualifiers. However, if this is being loaded via a UNIX environment modifying...
14307 Feb 2012 @ 05:12 PSTUDAReplyParsing/Response Fairly certain that once the query has reached a RESPONDING state TASM workload settings do not effect it. The duration which a query remains in RESPONDING state depends on environmental factors...
14207 Feb 2012 @ 05:06 PSTToolsReplyBest Memory specification for SQL Assistant V13 Memory for PCs and Notebooks is relatively cheap. I would suggest for the overall performance of your computer to upgrade to at least 2GB of RAM if it supports it. Personally, I am running 8GB o...
14106 Feb 2012 @ 12:56 PSTDatabaseReplyPerformace of Count(Distinct) Are these simple SELECT statements or more complex queries with multiple joins? 
14006 Feb 2012 @ 10:53 PSTDatabaseReplyFastest way to update a table joining to a huge table I would suggest looking at the MERGE statement in the Teradata Manuals. It will allow you to manage both the INSERT and UPDATE actions (UPSERT) whether the matching record exists in the table in...
13906 Feb 2012 @ 10:33 PSTViewpointTopicValue List Compression Portlet Are there any plans to introduce a portlet that mimics the behavior of AtanaSoft's CompressTool on Viewpoint? (Maybe even license the IP from AtanaSoft or work with AtanaSoft for them to dev...
13824 Jan 2012 @ 08:19 PSTGeneralReplyNewbie -- where to start learning teradata? Are you looking to become familiar with Teradata from a DBA or developer perspective?
13716 Nov 2011 @ 06:39 PSTDatabaseReplyROW LEVEL COMMITS IN TERADATA Kaushik, I would defer to Jimm's more complete answer. Good luck with your testing.
13615 Nov 2011 @ 06:43 PSTDatabaseReplyROW LEVEL COMMITS IN TERADATA If you are operating in Teradata mode and allowing dirty reads of the table (access locking or row access locking) your users should be able to see the data as the table is being loading. &n...
13515 Nov 2011 @ 03:54 PSTPrivate Forum

Pages