| 68 | 11 Feb 2014 @ 05:29 PST | Database | Reply | dynamic index collect stats statement | Thanks Guys!
I tried udfconcat but I believe it pulls back all the index columns (primary and secondary) on the same line. Do you know of any way to only pull the UPI or USI columns? I... |
| 67 | 10 Feb 2014 @ 05:03 PST | Database | Reply | dynamic index collect stats statement | I was able to utilize a 3th party SP called Run_Index_CS_SP to collect stats on primary and secondary indexes. Still curious to see if anyone has been able to generate dynamic sql similar to ... |
| 66 | 10 Feb 2014 @ 04:21 PST | Database | Topic | dynamic index collect stats statement | Hi all,
I would like to execute some dynamic sql that goes out to a table and pulls back the columns of a primary index and plugs them into a collect statistic statement. Something like:
se... |
| 65 | 17 Dec 2013 @ 04:21 PST | Database | Reply | Collect stats doubt | Thanks Saeed!... that is what I thought. For those customers on versions prior to 14.00, it is good to know that order matters when it comes to multi-column statistics collection. Nothi... |
| 64 | 13 Dec 2013 @ 08:43 PST | Database | Reply | Collect stats doubt | I'm not sure if this applies to 14, but prior versions are a bit tricky when collecting multicolumn stats. The optimizer only looks at the first 16 bytes of data. For example, if I ... |
| 63 | 28 Oct 2013 @ 11:11 PDT | Database | Topic | Compiling Stored Procedures with No SPL (No Stored Procedure Language) | I have a few user stored procedures in our TEST environment that I would like to re-compile. These procs do not have any stored procedure language associated with them. When I try to sh... |
| 62 | 13 Sep 2013 @ 11:25 PDT | Database | Reply | How to get data from Excel to Teradata table without using teradata olap connector | Try the following:
1. Save your spreadsheet as tab delimited
2. Open up SQLA
3. Navigate to File and select 'Import Data'
4. Compose something similare to:
ins... |
| 61 | 30 Aug 2013 @ 09:41 PDT | Tools | Reply | TPT Installation Verification Script | I believe I have found it so thought I would also share...
The script is called tptvalidate.bat and is located in the following directory:
C:\Program Files (x86)\Teradata\Client\14.00\Teradata Pa... |
| 60 | 30 Aug 2013 @ 09:14 PDT | Tools | Topic | TPT Installation Verification Script | At one time I found a script that I had been able to run in order to verify a TPT installation. I am upgrading the TTU from 13.10 to 14.0 on an ETL Windows server. I would like to use t... |
| 59 | 12 Jun 2013 @ 10:45 PDT | Data Modeling | Reply | Effect of reversing the order of columns in mutli-column stats | I believe the order is determined by the order in which the columns are defined in the table definition (up to 13.10). It is a good practive to define smaller sized columns first just in case... |
| 58 | 30 Apr 2013 @ 10:07 PDT | Database | Topic | Expired Password Prompt | Every now and then I run into a situation where a user's password expires and I am not able to reset the password to produce a prompt to change. I run all users through a profile. I... |
| 57 | 26 Apr 2013 @ 08:31 PDT | Database | Topic | Informatica ODBC Error | Have any Informatica users out there ever encountered the following failure:
Severity: ERROR
Timestamp: 4/26/2013 10:51:03 AM
Node: node01_DVWPAP0031
Thread: READER_1_1_1
Process ID: 1... |
| 56 | 12 Apr 2013 @ 02:56 PDT | Database | Reply | disable enable logons | I was playing around a bit and came up with the following... Not sure if this is what you are looking for:
sel 'revoke logon on all from ' || '"' || trim(databasename) || '... |
| 55 | 10 Apr 2013 @ 03:31 PDT | Database | Topic | Teradata DBLink | A question that I get from developers on a routine basis is "When is Teradata going to develop DB Links?" As a DBA, I could use this functionality as well. Has anyone else eve... |
| 54 | 04 Apr 2013 @ 10:36 PDT | Database | Reply | No More Spool Space.... on which AMP? | Just out of curiosity.... why do you need to know which AMP? Is it to determine null values?
|
| 53 | 23 Mar 2013 @ 02:09 PDT | Database | Reply | MVC is helpful for running queires | No one can say for sure because of all the unknowns associated with your situation and queries, but more rows per block many time results in better query performance. Usually MVC can achieve ... |
| 52 | 23 Mar 2013 @ 01:58 PDT | Database | Reply | Data movement across Terdata server | If the requirements permit it, I usually move data from a backup between systems. There are usually faster connections to your backup media and the source system is not effected by a Fast Exp... |
| 51 | 14 Mar 2013 @ 03:05 PDT | Database | Reply | DBLink in Teradata | Possible good news... I get this request often... Teradata may try to develop this in a future release... does not currently exist.
|
| 50 | 13 Mar 2013 @ 03:06 PDT | Tools | Reply | SQLA - Deleting Add Favorites Entries | Dang Dieter.... How did you know that? :) I looked for documentation everywhere and couldn't find it!
Thank you very much!
Joe
|
| 49 | 08 Mar 2013 @ 07:26 PST | Tools | Topic | SQLA - Deleting Add Favorites Entries | I am on SQA 14.0 and am trying to figure out a way to delete an entry I have created in 'Add Favorites'. I love this feature but am not able to clean up old entries. Does anyone... |
| 48 | 06 Feb 2013 @ 07:38 PST | Database | Reply | ETL Process results in contention on Teradata table | Have you created a view on top of each table defined as LOCK ROW FOR ACCESS? Writing directly against the table, instead of through the view, may be your issue.
|
| 47 | 05 Feb 2013 @ 10:31 PST | Database | Topic | Survey: ERP Source = UTF8, Teradata Column definitions = (Latin or Unicode)? | I would like to conduct a bit of a survey from all those Teradata customers out there that pull from Unicode sources (i.e. SAP).
When setting up the EDW, which of the following scenarios would you... |
| 46 | 05 Feb 2013 @ 10:22 PST | Database | Reply | Stored Procedure Input Parameter Problem | Thanks Dieter,
That is exactly what it was.... operator error! :)
Joe
|
| 45 | 30 Jan 2013 @ 05:42 PST | Database | Topic | Stored Procedure Input Parameter Problem | I have created a basic stored procedure whose parameters are defined as:
REPLACE PROCEDURE STORED_PROCS.SP_UPDATE_SAP_CTRL_TABLE
(IN "in_DELTA_BUFFER_HR" integer,
IN "in_D... |
| 44 | 14 Dec 2012 @ 10:50 PST | Database | Topic | Table references in a COMPLEX view | We have defined a view layer on top of all tables in our edw. For example, every tabledatabase.table_t has a corresponding view defined as viewdatabase.table. We have a semantic view la... |