19 | 30 Oct 2015 @ 12:37 PDT | Database | Reply | Tracing stored procedure parameter values | you need to enable this replace Query Logging with PARAMINFO on ALL; (or specific account you would like to).
The only issue i had is that i can trace any store proc parameters e... |
18 | 18 Jun 2013 @ 08:46 PDT | Database | Reply | MERGE vs UPSERT | How can i do an upsert into teradata table(DEV) by comparing PRD table. Looking for a way to synch DEV table to PRD table and make them identical as there are some changes made to the existing... |
17 | 17 Apr 2013 @ 04:47 PDT | Database | Reply | Revoking All Access Rights For Users | is it possible to revoke access to everyone on a database? |
16 | 15 Jan 2013 @ 07:13 PST | Tools | Reply | Fastload error :when trying to load data using fastload from BTEQ exported data file | Is there a way to diasble the fall back option for fastload error tables? It seems like by default error tables will have fallback option enbaled in 13.10.
|
15 | 13 Aug 2012 @ 07:20 PDT | Database | Topic | Teradata 13 Vs 14 |
Can someone please layout any major differences with these 2 versions or point me to any document that shows the every change. I have read few details about that but wanted dive into more d... |
14 | 18 Jun 2012 @ 11:54 PDT | Tools | Topic | RDBMS error 2633 Too many load/unload task running |
I am getting this error when i try to run a fastload job specifying just 1 session in the script. I know there is a limitation of 30 load jobs on the applicance and so when i checked on viewpoin... |
13 | 11 Jun 2012 @ 11:02 PDT | Database | Topic | Import/Export from Teradata to SQL Server |
we have been moving data using SQL Server using Linked Server(ODBC driver) and TPT using attunity but these 2 options are very slow in speed. Is there any other method or may be some 3... |
12 | 30 Apr 2012 @ 08:31 PDT | Tools | Reply | Fastload error-Kindly Help!! |
How can i find maximum allowed sessions on my system. If a fload script doies not mention session number how many sessions it would take to run the load on a 12 node system.
|
11 | 24 Apr 2012 @ 06:22 PDT | Tools | Topic | Best Practice - Client Tools |
What is the best practice to use SQL Assitance and Teradata Manager from end user point. Currently we install all client tools on a windows VMware machine and all the users access the tools by R... |
10 | 19 Jan 2012 @ 12:51 PST | Database | Reply | Performance problem |
that makes sense i agree but in this situation what are the options i have to gain performance.
|
9 | 19 Jan 2012 @ 07:03 PST | Database | Reply | Performance problem |
80% of the records has 1 and the rest 0 but most the time we qry on 1.
|
8 | 19 Jan 2012 @ 06:29 PST | Database | Reply | Performance problem |
yes, i tried that already it does not make any difference.
|
7 | 19 Jan 2012 @ 03:13 PST | Database | Topic | Performance problem |
I have a table of 2tb with MV compression and when i do a query using a where clause of an indiacator which has just 2 values either 0 or 1, the performance is really bad there is a difference o... |
6 | 21 Oct 2011 @ 10:11 PDT | Viewpoint | Reply | MyQuery Portlet setup. |
yes i do, though i was thinking all other tabs would appear only if the threshods are met but i am assuming SQL and EXPLAIN tab has to appear by default.
|
5 | 21 Oct 2011 @ 07:11 PDT | Viewpoint | Reply | MyQuery Portlet setup. |
Thanks Steve, i got that. Also when i drill down to a session except the overviee tab all other tabs(explain.sql,queryband etc ) are grayed out, is there any setting that i have to enable for th... |
4 | 20 Oct 2011 @ 11:54 PDT | Viewpoint | Reply | MyQuery Portlet setup. |
I am in the same situation, did you get it resolved?
|
3 | 27 Sep 2011 @ 08:49 PDT | Viewpoint | Topic | Info on Viewpoint Database |
I think viewpoint miantains its own database in Postgre, is there a way i can find details about that database and query it? Also i would like to know the capacity limit of the database
|
2 | 17 Sep 2011 @ 07:31 PDT | Database | Topic | Understanding Spool Space |
Need some clarity on spool space allocation.
1. Lets say i have a user "user1" has a perm space 100gb and spool space 500gb (shared between 10 users) and user1 has a... |
1 | 31 Aug 2011 @ 10:24 PDT | Database | Reply | Adding Compression to existing table |
I think this should be fixed in 13.10, right?
|