159 | 14 Nov 2014 @ 10:15 PST | Teradata Studio | Reply | Feature Requests | Thank you for the update! Hopefully you can remediate the JDBC driver issue soon.
|
158 | 14 Nov 2014 @ 09:16 PST | Teradata Studio | Topic | Feature 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... |
157 | 28 May 2014 @ 06:50 PDT | Database | Reply | DBQL AMPCPUTime and TDWM Exception Abort | In 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... |
156 | 28 May 2014 @ 06:40 PDT | Database | Reply | Best 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... |
155 | 08 Oct 2012 @ 10:08 PDT | Database | Reply | partition question | What do your table statistics look like?
Generally an inequality condition is going to result in a FTS.
|
154 | 05 Oct 2012 @ 05:12 PDT | Database | Reply | SQL to find Row Count | Learned 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... |
153 | 04 Oct 2012 @ 06:41 PDT | Database | Reply | SQL to find Row Count | No. 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... |
152 | 04 Oct 2012 @ 10:36 PDT | General | Reply | Wish list for forum development | Is 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... |
151 | 03 Aug 2012 @ 02:39 PDT | Tools | Reply | Alter 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... |
150 | 02 Aug 2012 @ 09:11 PDT | Viewpoint | Topic | Query 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... |
149 | 01 Aug 2012 @ 05:23 PDT | General | Reply | PDCR 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.
... |
148 | 14 Feb 2012 @ 05:44 PST | Tools | Reply | TTU 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.
|
147 | 13 Feb 2012 @ 09:10 PST | Database | Reply | Performace 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... |
146 | 08 Feb 2012 @ 12:22 PST | Tools | Reply | Best 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... |
145 | 07 Feb 2012 @ 08:58 PST | General | Reply | next 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?
|
144 | 07 Feb 2012 @ 08:54 PST | Tools | Reply | Text 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... |
143 | 07 Feb 2012 @ 05:12 PST | UDA | Reply | Parsing/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... |
142 | 07 Feb 2012 @ 05:06 PST | Tools | Reply | Best 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... |
141 | 06 Feb 2012 @ 12:56 PST | Database | Reply | Performace of Count(Distinct) |
Are these simple SELECT statements or more complex queries with multiple joins?
|
140 | 06 Feb 2012 @ 10:53 PST | Database | Reply | Fastest 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... |
139 | 06 Feb 2012 @ 10:33 PST | Viewpoint | Topic | Value 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... |
138 | 24 Jan 2012 @ 08:19 PST | General | Reply | Newbie -- where to start learning teradata? |
Are you looking to become familiar with Teradata from a DBA or developer perspective?
|
137 | 16 Nov 2011 @ 06:39 PST | Database | Reply | ROW LEVEL COMMITS IN TERADATA |
Kaushik,
I would defer to Jimm's more complete answer. Good luck with your testing.
|
136 | 15 Nov 2011 @ 06:43 PST | Database | Reply | ROW 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... |
135 | 15 Nov 2011 @ 03:54 PST | Private Forum |