| 3706: Syntax error [Wed, 12 Sep - 13 Posts] 
 
 A TPT with Load operator [Wed, 14 Nov - 5 Posts] A user with 2 roles [Thu, 06 Sep - 3 Posts] Access Logging - Impact on performance [Mon, 26 Nov - 6 Posts] Actual size of CLOB fields [Thu, 15 Mar - 2 Posts] Add a carriage return character in a string? [Thu, 22 Mar - 2 Posts] add_months for integer-type dates [Thu, 20 Sep - 4 Posts] Adding Compression - Redistributing data [Tue, 06 Nov - 2 Posts] Adding intervals dynamically. [Sat, 11 Feb - 3 Posts] Admin Comment: Apparent DOS Attack [Thu, 13 Sep - One Post] AMP & DISK skewness during fastload [Thu, 31 May - One Post] AMP CPU Skew Failures [Sat, 17 Nov - 3 Posts] Announce: Teradata::SQL 0.10 [Sun, 01 Jan - One Post] ARCMAIN warning with PPI tables [Fri, 18 May - 4 Posts] Automatic Script to collect stats on index and defined columns [Wed, 18 Jul - 6 Posts] Automation of Stats collection through Viewpoint [Fri, 13 Jan - One Post] Avoiding Multiple Views [Thu, 06 Sep - 8 Posts] AWT Run Out [Tue, 14 Aug - 8 Posts] 
 
 Backing up table before dropping [Mon, 02 Apr - 4 Posts] Backup failure - ARC0805 [Thu, 06 Sep - 5 Posts] BLC at table creation [Tue, 29 May - 5 Posts] BTEQ EXPORT FILES [Tue, 14 Aug - 2 Posts] BTEQ history [Thu, 01 Mar - 3 Posts] 
 
 Calling stored procedures and macros from Eclipse [Thu, 03 May - 3 Posts] Can I activate a new TASM rule via SQL? [Wed, 05 Dec - 3 Posts] Can we CALL more than one procedure in within macro...? [Tue, 28 Aug - 4 Posts] Can we do partion by in timestamp(6) columns ? [Fri, 20 Jul - One Post] Can't drop a range of rows [Fri, 07 Dec - 4 Posts] Can't find AMP CPU, Delta CPU, Delta I/O, AMP I/O in TD Manager [Mon, 27 Feb - 2 Posts] Carriage return character in a string [Sat, 29 Dec - 3 Posts] Changing priority of a running query [Tue, 31 Jul - 4 Posts] Changing table columns varchar (20) to varcahr [Fri, 20 Jul - One Post] Changing Table Protection From No Fallback to [Tue, 06 Nov - 5 Posts] Cnsrun with dumplocklog [Tue, 30 Oct - 8 Posts] Codd's rules in teradata [Fri, 27 Jul - 4 Posts] Collect stats inside a macro [Mon, 10 Dec - 3 Posts] Collect stats on tables rather than columns [Mon, 23 Jul - 3 Posts] Collect stats on VT in TD13.10 [Wed, 20 Jun - 4 Posts] Collecting statistics on volatile table in [Thu, 19 Jul - 2 Posts] Command to Check AMP condition [Mon, 26 Mar - 3 Posts] Comparing Data between db2 and Teradata [Wed, 12 Dec - One Post] Compress column with 2 values [Fri, 23 Mar - 3 Posts] Compress Null value [Mon, 16 Jan - 12 Posts] Compress Primary Key Columns [Tue, 24 Apr - 3 Posts] Compress special characters - single quote [Thu, 08 Nov - 4 Posts] Compression and the Optimizer [Wed, 10 Oct - 2 Posts] Compression in Arcmain 13.1 [Tue, 06 Mar - 6 Posts] Compression Process on Teradata 13.10 [Tue, 02 Oct - 21 Posts] Computing 3rd Saturday of the month [Wed, 25 Jan - 8 Posts] Concept of Index Only Scans in Teradata? [Tue, 07 Aug - 4 Posts] Configuring Alerts on Manager Version 13.0 [Wed, 11 Apr - 7 Posts] Connect R to Teradata [Wed, 05 Sep - 4 Posts] Connect to Teradata from Visual Basic [Wed, 15 Aug - 2 Posts] Connecting to new port [Sat, 25 Feb - 2 Posts] Connection errors from host to TD Express 13.10 VMWare [Wed, 05 Dec - 9 Posts] Connection problem [Thu, 18 Oct - 3 Posts] Converting TIMEZONE data to Specific Region Time Value [Fri, 17 Feb - 6 Posts] Converting to date format [Fri, 14 Dec - 5 Posts] Copy data from backup [Wed, 29 Aug - 12 Posts] Copy table across dev. and prod [Thu, 14 Jun - 2 Posts] CPU skew processing a query [Sat, 29 Dec - One Post] Create table and insert data within Stored [Wed, 29 Aug - 2 Posts] Creating a new table by copying other table with a portion of data [Fri, 07 Dec - 8 Posts] Creating a script with TPT Wizard [Mon, 19 Mar - One Post] Creating Sequence Number In Table To Fix Amp Skew [Wed, 05 Dec - 8 Posts] Cube, Rollup and Grouping sets [Tue, 11 Dec - 3 Posts] Cursor In a Procedure - Compilation error [Wed, 20 Jun - One Post] Cursor Inside a trigger [Fri, 15 Jun - 2 Posts] 
 
 Data collector Down Alert [Thu, 18 Oct - 3 Posts] Data Migration From DB2 [Tue, 18 Sep - 3 Posts] Data migrator blocking prod tables [Thu, 12 Apr - One Post] Data movement using Data Mover [Fri, 23 Mar - One Post] Data PULL when Teradata is the EDW [Fri, 16 Nov - 3 Posts] Database performance daily reports [Thu, 31 May - One Post] Database recovery [Mon, 24 Sep - 3 Posts] Database space usage Alerts [Wed, 17 Oct - 9 Posts] Datamodeling Teradata table definitions [Mon, 30 Apr - One Post] Date conversion not working [Tue, 30 Oct - 9 Posts] DATE Format 'YYDDD'? [Tue, 29 May - 5 Posts] DB2 to Teradata [Wed, 18 Apr - 2 Posts] Dbaseid and unknown creator [Wed, 04 Apr - 4 Posts] DBC Tree View [Wed, 24 Oct - 10 Posts] DBQL - CPUTIME and CPUTIMENORM [Mon, 02 Jul - 3 Posts] DBQLSTEPTBL Logging [Fri, 14 Dec - 2 Posts] DDL inside macro definition [Tue, 11 Dec - 4 Posts] Debugging a procedure [Fri, 24 Feb - 7 Posts] Debugging a Stored Procedure [Sat, 29 Dec - One Post] Define stats on multiple columns on a GTT [Wed, 01 Aug - 2 Posts] Delete and Insert based on Load flag [Tue, 03 Jan - 3 Posts] Delete query based on target table date [Thu, 13 Dec - 5 Posts] Delete/load or mload insert for missing update [Wed, 26 Sep - One Post] Deleting records from DBC.TransientJournal table [Thu, 07 Jun - 6 Posts] Deleting rows from a table which EXIST in another table [Tue, 18 Dec - 3 Posts] Diff between Date in hours [Fri, 06 Apr - 2 Posts] Difference between 3523 and 5315 [Sun, 09 Sep - 9 Posts] Difference between BYNET and YNET? [Mon, 02 Apr - 2 Posts] Difference between GROUP BY and DISTINCT in TD 14. [Fri, 20 Jul - 4 Posts] Difference between TD 13.10 and TD 12? [Wed, 06 Jun - 3 Posts] Difference in table creation. [Fri, 06 Apr - 4 Posts] Different AMP CPU time on same query [Tue, 31 Jan - 4 Posts] Dirty Read in teradata [Tue, 04 Dec - 4 Posts] Display settings of DBS Control and xctl [Thu, 25 Oct - 2 Posts] Distinct count in select & insert [Mon, 23 Jul - One Post] Documentation on Teradata Optimizer [Tue, 24 Jan - 5 Posts] Doubt with indexes [Mon, 26 Nov - 7 Posts] DPE dosen't work when using EXTRACT function [Thu, 22 Mar - One Post] Drop Table versus Delete All [Tue, 03 Apr - 3 Posts] Dropping and creating secondary index in Mload [Tue, 17 Jan - One Post] Dropping stats and collecting PI stats [Tue, 24 Jan - 2 Posts] Dropping stats on indexes [Thu, 03 May - 4 Posts] Duplicate to all amps [Tue, 21 Feb - 5 Posts] Dynamic Result Sets [Tue, 24 Jul - 3 Posts] 
 
 Enable users: temporary password? [Fri, 17 Feb - 6 Posts] Errlimit doesn't work with FASTLOAD... [Fri, 05 Oct - One Post] Error - 3149:TDWM Filter violation for Query Request [Mon, 23 Jul - 6 Posts] Error - 3504 :- Selected non-aggregate values must be part of the associated group. [Wed, 12 Sep - 8 Posts] Error 2825: No record of the last request was [Thu, 19 Apr - One Post] Error 3278: No Monitor Session available [Wed, 19 Sep - 6 Posts] Error 5505 - Column data types cannot be specified [Fri, 14 Sep - 2 Posts] Error 6706 [Wed, 11 Apr - 9 Posts] Error in Modify the history data [Tue, 26 Jun - One Post] Error in running a macro: INSERT Failed. [Tue, 31 Jan - 3 Posts] Error in TPT Stream script [Wed, 04 Apr - 2 Posts] Error loading data from DB2 through TPT using [Tue, 25 Sep - 2 Posts] Error messages while launching TD SQL Assistant [Tue, 11 Sep - 2 Posts] Error starting Teradata Express 14 on VMWare [Fri, 12 Oct - 3 Posts] Error while accessing TERADATA using SAS [Mon, 02 Apr - 2 Posts] Error while loading table using fastlaod [Thu, 19 Jan - 7 Posts] Errors in Backup - BAM1206: Tivoli server aborted transaction [Mon, 16 Jan - 7 Posts] ETL tool cannot update/insert data [Fri, 18 May - 4 Posts] Excessive Stats [Wed, 21 Nov - One Post] Executing query stored in a table through BTEQ [Tue, 21 Feb - 2 Posts] Explain Plan differences between Static and Dynamic SQL [Mon, 25 Jun - 6 Posts] Explanation for this blocked session: Artificial session [Sat, 21 Jan - 2 Posts] Extracting a String From End [Mon, 30 Apr - 10 Posts] 
 
 Fast Export 2GB file Limit [Wed, 05 Sep - 11 Posts] FastExport: Conversion issues with exported [Thu, 21 Jun - One Post] Feedback for SQL Assistant Ver 13 [Tue, 14 Aug - 3 Posts] Find record position for Fastload/Multiload error [Mon, 20 Feb - 4 Posts] Find tables to run collect statistics [Thu, 15 Mar - 5 Posts] Find the SQL running in the system [Tue, 13 Mar - 3 Posts] Finding a dropped user [Thu, 12 Jul - 3 Posts] Finding day of the week. [Sat, 10 Mar - 5 Posts] FLOAD Locks [Thu, 15 Mar - 3 Posts] 
 
 Generate collect statistics statement [Thu, 12 Jan - 33 Posts] Geoserver - servers enabling [Fri, 10 Feb - 2 Posts] Geoserver and Monitor extension [Fri, 10 Feb - 3 Posts] Grant & Role Issue [Fri, 19 Oct - 8 Posts] Grant Abort Session [Thu, 25 Oct - 12 Posts] Grouping the data and pulling the max value when different windows exist [Tue, 11 Sep - 3 Posts] 
 
 Help needed in writing SQL [Wed, 29 Aug - 3 Posts] Help needed with Lead and Lag functions [Thu, 20 Dec - 3 Posts] Help required in casting the date [Wed, 18 Apr - 6 Posts] HELP TABLE output. [Wed, 18 Jul - 2 Posts] Help with changed password [Mon, 23 Apr - 10 Posts] Help with compression analysis [Wed, 25 Jul - 2 Posts] HELP: SELECT failed. 3706: Syntax error [Thu, 22 Mar - 5 Posts] History data Modification [Wed, 13 Jun - One Post] How data in SPOOL distributed? [Mon, 04 Jun - 2 Posts] How DISTINCT and GROUP BY have same performance in TD 14 [Tue, 06 Nov - 3 Posts] How does Teradata work when merge join on MVC [Thu, 21 Jun - 4 Posts] How Hashing algorithm works? [Thu, 05 Apr - 5 Posts] How many parameters can be passeed in stored [Fri, 24 Aug - 2 Posts] How records get hashed if PI value is NULL? [Wed, 21 Mar - 11 Posts] How to ALTER  GTT table from LOG to NO LOG [Wed, 14 Nov - 2 Posts] How to calculate average endtime irrespective to run date [Mon, 22 Oct - 4 Posts] How to call Stored procedures using Triggers [Thu, 19 Jul - 3 Posts] How to CAST a number without getting a decimal point. [Tue, 17 Jan - 9 Posts] How to change read source sequence limit in Multi Load [Thu, 06 Dec - 2 Posts] How to clear the Orphan Access rights [Fri, 10 Feb - 8 Posts] How to compress timestamp type [Wed, 09 May - 10 Posts] How to Convert a VARCHAR date into TIMESTAMP(0) format [Fri, 26 Oct - 9 Posts] How to copy database tables [Mon, 21 May - 3 Posts] How to copy table containing identity column? [Mon, 10 Dec - 5 Posts] How to delete special characters in a string [Thu, 12 Jul - 7 Posts] How to deploy sdk portlet on to production viewpoint [Mon, 23 Jul - One Post] How to Deploy UDF in Teradata [Sun, 03 Jun - 6 Posts] How to disable retry in Fast Export [Thu, 06 Dec - One Post] How to do an collect stats on more than one [Mon, 01 Oct - 4 Posts] How to Do NsLookup [Tue, 20 Mar - 7 Posts] How to Enable Resusage tables? [Tue, 20 Nov - 6 Posts] How to Exit SQL-A? [Thu, 13 Sep - 2 Posts] How to find Chinese character in string? [Fri, 09 Nov - 2 Posts] How to find column is nullable or not nullable [Wed, 24 Oct - 2 Posts] How to find data type and nullability [Fri, 19 Oct - 5 Posts] How to find duplicate record [Wed, 28 Mar - 11 Posts] How to generate Surrogate Key using CSUM? [Wed, 07 Nov - 12 Posts] How to get the IP address of the TD machine [Mon, 05 Mar - 9 Posts] How to Identify UNUSED STATS on a table? [Tue, 06 Nov - 16 Posts] How to install DBD:Teradata on Perl64 [Sun, 07 Oct - One Post] How to install ODBC driver on Solaris not in [Thu, 30 Aug - One Post] How to know the Aborted Session Details [Mon, 04 Jun - 4 Posts] How to load Hexadecimal data [Tue, 27 Nov - 4 Posts] How to look-up a table locked by Fastload [Mon, 31 Dec - One Post] How to map WDID with Workload Description [Sat, 02 Jun - 7 Posts] How to move a session from Delayed state to [Tue, 16 Oct - 4 Posts] How to remove dot (decimal) from exported file [Tue, 06 Nov - 5 Posts] How to replace with null if date is invalid [Tue, 21 Aug - 10 Posts] How to restart Fload and Mload [Fri, 06 Jul - 5 Posts] How to ROLLBACK a successful transaction [Tue, 27 Nov - 5 Posts] How to run Update statement faster [Tue, 26 Jun - 4 Posts] How to shell variable inside a bteq script? [Fri, 27 Jan - 4 Posts] How to split full name to first,middle & last [Mon, 16 Jul - 8 Posts] How to uniquely access a row? [Thu, 02 Aug - 2 Posts] How to write ERWin macro to support compress? [Wed, 19 Sep - 6 Posts] 
 
 I/O, CPU and AMP SKEW [Sat, 29 Dec - 7 Posts] Icons in Teradata PMON [Thu, 03 May - 3 Posts] Ideal TPUMP Sessions [Thu, 29 Nov - 6 Posts] Identifying empty views, or conditions, that make the query fruitless [Thu, 26 Jan - One Post] Impact on spool between SELECT TOP and with ORDER BY [Thu, 07 Jun - 3 Posts] Improving the performance of a minus query [Fri, 06 Jan - 4 Posts] IN Vs = [Equality] [Tue, 22 May - 3 Posts] In where condition 'not' and 'and is not working together [Mon, 24 Sep - 7 Posts] Inactive sessions aborted via TASM [Fri, 07 Dec - 3 Posts] Increase a column length [Wed, 14 Nov - 2 Posts] Increase/decrease packet size in TPUMP [Thu, 15 Mar - 2 Posts] Index Best Practices for Dimension Model Data? [Thu, 14 Jun - 3 Posts] Indexes on Timestamp Columns [Mon, 20 Feb - 2 Posts] Informatica and Mload Errors [Wed, 24 Oct - 2 Posts] Insert a large varchar field into a clob or st_geometry field [Fri, 11 May - 3 Posts] Insert Char values in column defined as Integer [Wed, 12 Sep - 4 Posts] Insert into table with same select is too slow [Mon, 16 Jul - 10 Posts] Insert statement starts OK but then slows down [Wed, 18 Jul - 18 Posts] Insert When [Wed, 07 Mar - 4 Posts] Installation of TD Express for VMware Player [Fri, 04 May - 11 Posts] Intermittent - Numeric value out of range: Teradata ODBC problem [Sat, 21 Jul - One Post] Is there a difference between these CT's [Sat, 21 Jul - 2 Posts] Is there a way to find the number of a table [Thu, 28 Jun - 4 Posts] Issue getting a rank [Thu, 12 Jan - 2 Posts] 
 
 JDBC Parameterized Query -- Cache hit Ratio [Thu, 08 Nov - One Post] Joining TIMESTAMP vs DATE [Wed, 04 Apr - 2 Posts] 
 
 Last Access Timestamp and Archive [Tue, 03 Apr - One Post] Last operation on a database object [Wed, 30 May - 3 Posts] Lenth of String without using Lengh functions [Fri, 16 Mar - 5 Posts] Libpm.dll is missing [Mon, 12 Mar - 5 Posts] Like keyword issues with % [Wed, 07 Mar - 7 Posts] Limitations of WHILE loop in Stored Procedures [Mon, 06 Aug - One Post] LIST ROLLBACK TABLES; [Wed, 11 Jan - 11 Posts] Load Balancing on report query [Tue, 08 May - 5 Posts] Load Oracle EXPORTS binary output to Teradata [Thu, 19 Jul - One Post] Loading Special Characters [Tue, 05 Jun - 4 Posts] Locking within views [Fri, 16 Mar - 2 Posts] LOG / NO LOG in GTT and VT [Mon, 12 Nov - 2 Posts] Login with several nodes [Fri, 03 Feb - 3 Posts] Logon time interpretation [Thu, 15 Mar - 5 Posts] 
 
 Macro - String Parsing [Thu, 09 Feb - 2 Posts] Macros vs Stored Procedures for DML statements only [Wed, 30 May - 2 Posts] Materialized view and view [Fri, 27 Jul - 3 Posts] Max Vdisk size in TD 14 [Fri, 02 Nov - One Post] Maximum  columns  in TPT [Fri, 24 Aug - 2 Posts] Maximum number of foreign key in a table in Teradata? [Thu, 27 Dec - 6 Posts] MDS and Automatic DIM Updates [Mon, 13 Aug - One Post] Meaning of Translate word in Explain plan [Thu, 19 Jul - One Post] Memory settings in TPT script [Thu, 11 Oct - One Post] Migrating from 13.0 to 13.10 [Mon, 24 Sep - One Post] Migration of Oracle to Teradtaa [Sat, 21 Apr - 3 Posts] Minimum number of sessions [Tue, 22 May - 3 Posts] Missing a setting here ..can't recollect what [Mon, 09 Jan - 9 Posts] Missing space in the Database [Fri, 16 Mar - 6 Posts] Mload layout in unix [Tue, 21 Aug - 5 Posts] Mload loading junk value [Wed, 15 Feb - One Post] Mload sessions are going into IDLE [Fri, 13 Jan - One Post] More than one User Profile [Thu, 16 Aug - 8 Posts] Moving data from Oracle and SQL Server to [Wed, 04 Jan - 2 Posts] MQ Websphere connection to Teradata [Mon, 24 Sep - 2 Posts] Multi-column statistics and truncation [Thu, 31 May - One Post] Mutli-Column Stats [Tue, 24 Apr - 6 Posts] MVC and Presence bits [Fri, 03 Feb - 2 Posts] 
 
 Name of Hashing algorithm [Thu, 05 Apr - One Post] Need best practise information [Thu, 27 Dec - One Post] Need Help with Perfomace Issue [Thu, 11 Oct - 3 Posts] Need help with Stored Procedure: SELECT INTO clause [Tue, 09 Oct - 2 Posts] Need to transpose a column to Row [Tue, 09 Oct - 4 Posts] Netbackup Email set up [Wed, 12 Dec - One Post] New reserved keywords in Teradata Version 13.0? [Thu, 12 Apr - 5 Posts] New Users not in DBC.LOGONRULES table [Fri, 16 Mar - 4 Posts] No more room in the Journal table [Thu, 30 Aug - 8 Posts] No. of AMPs in a NODE [Thu, 22 Nov - 6 Posts] NODE Downsizing Tasks [Tue, 28 Aug - 2 Posts] Not getting email notification [Fri, 27 Jan - 2 Posts] Number of times a string appears in a sentence [Wed, 22 Aug - 4 Posts] Numeric overflow while doing UNION [Fri, 26 Oct - 5 Posts] 
 
 OLEDB_AXSMOD error on FastLoad script [Fri, 20 Jan - 2 Posts] OLELOAD and XML [Tue, 10 Jul - One Post] OLELOAD: 2008 SQL Server to Teradata [Mon, 02 Jul - 2 Posts] Order by Hash? [Thu, 17 May - 3 Posts] OREPLACE : Special Characters [Fri, 06 Jul - 3 Posts] OS in which TD work [Thu, 11 Oct - 5 Posts] OVERLAPS question [Mon, 29 Oct - 6 Posts] 
 
 Parallel Efficiency [Thu, 11 Oct - 12 Posts] Parameter name missing [Fri, 11 May - 4 Posts] Partitioning on different column to PI [Thu, 08 Mar - 10 Posts] Partitioning startegy for 1.2 Terabytes [Wed, 25 Apr - One Post] PDCRDATA Clean up [Thu, 27 Dec - One Post] PE plan for join [Fri, 27 Jul - 3 Posts] Perf Issues in Empty partition Scan [Tue, 18 Dec - 3 Posts] Performance between development and production systems [Thu, 17 May - 11 Posts] Performance difference between IN and NOT IN [Tue, 26 Jun - One Post] Performance Metrics: What explains this kind of observation? [Wed, 25 Jan - 4 Posts] Performance Queries [Tue, 03 Apr - One Post] Perl with TD 14 on Linux [Tue, 21 Feb - 2 Posts] Permanent Jounal questions [Tue, 28 Feb - One Post] Permanent journal [Mon, 27 Aug - 3 Posts] Permissions at line level [Mon, 09 Jan - One Post] Point in time Recovery [Tue, 13 Mar - 2 Posts] Possible range of data skew [Tue, 10 Apr - 3 Posts] Preparing for Suse Linux [Mon, 09 Jan - 3 Posts] Primary and HSN [Sat, 30 Sep - 9 Posts] Problem with Alias in Teradata 14 [Thu, 06 Sep - 2 Posts] Procedure for updating the part of the string [Mon, 02 Jul - 2 Posts] Pseudo table lock? [Wed, 16 May - 4 Posts] Purpose of TRANSLATE command? [Sat, 21 Jul - 3 Posts] 
 
 Query consuming high spool [Thu, 12 Jul - One Post] Query Count & Resource usage data collectors not working. [Tue, 10 Jul - 2 Posts] Query is slower in SQL Assistant compared to batch? [Tue, 26 Jun - 2 Posts] Query on NUSI [Fri, 02 Nov - 5 Posts] Query on Teradata Amp and PE [Fri, 14 Dec - 5 Posts] Query performance issue - running long [Wed, 19 Sep - 6 Posts] Query related Fastload [Thu, 05 Jul - 2 Posts] Query to compare columns [Fri, 30 Mar - 5 Posts] Query to pull users last login date [Mon, 01 Oct - 5 Posts] Question on IO traffic origin from/to [Mon, 05 Nov - One Post] Question on Permanant Journals [Wed, 26 Dec - 3 Posts] Question on soft "RI" in Teradata [Wed, 31 Oct - 5 Posts] 
 
 R Functions & Teradata [Mon, 10 Sep - One Post] Recommendation on Table Lock [Mon, 02 Jul - 3 Posts] Record position for error record in Fastload [Sat, 04 Feb - 2 Posts] RedHat Linux 5 Teradata ODBC 13 connectivity [Tue, 21 Feb - 4 Posts] Redistribution when doing RANK() OVER on PI [Thu, 03 May - 4 Posts] Reduce the likelihood of a Full Table Scan [Thu, 03 May - 4 Posts] Referential Integrity in Teradata [Fri, 13 Jan - 4 Posts] Regarding Residual condition [Thu, 29 Mar - 5 Posts] Regarding stale stats [Wed, 29 Feb - 2 Posts] Regarding Table creation with PPI [Mon, 23 Jul - 2 Posts] Regular Maintainence Utilities [Fri, 30 Mar - One Post] Releasing mload pending from a table [Tue, 17 Jul - 3 Posts] Removing duplicates in Multiset table [Thu, 02 Aug - 8 Posts] Removing Junk characters [Mon, 19 Mar - 2 Posts] Rename Role name [Tue, 28 Aug - 2 Posts] Replace UDF failing with syntax error. [Thu, 19 Jul - 3 Posts] Resolving AMP CPU Skew Error [Fri, 21 Dec - 7 Posts] Restart Netvault backup [Fri, 06 Apr - 4 Posts] Restoring deleted rows [Tue, 29 May - 4 Posts] Restrcting the Access to PMON or TD Manager [Fri, 13 Jan - 6 Posts] Restricting concurrent sessions using throttles in TASM [Sat, 08 Dec - 6 Posts] Restriction on Space Movement [Tue, 27 Nov - 5 Posts] Retrieve next 50 rows after reference value [Fri, 24 Feb - 3 Posts] Rolforward to checkpoint from a Journal [Fri, 21 Sep - 11 Posts] Rollforward and Rollback using Permanent Journal [Thu, 21 Jun - One Post] Row Hash Lock [Tue, 27 Nov - 2 Posts] Running-out of DBC Space [Thu, 26 Jan - 12 Posts] 
 
 SAP-BW Cubes to Teradata [Wed, 05 Sep - One Post] Script stops after OREPLACE function [Fri, 29 Jun - 4 Posts] Second  minimum date [Wed, 28 Mar - 5 Posts] Security features at Teradata [Fri, 07 Sep - One Post] Select 'col1'N [Thu, 13 Sep - 3 Posts] Select records with valid values except the key field [Mon, 16 Jul - 9 Posts] Select statement not throwing error [Mon, 20 Aug - 4 Posts] Selecting a part of a table [Wed, 05 Dec - 7 Posts] Sending Teradata Manager Alerts using Lotus Notes [Thu, 08 Mar - One Post] Separation of duties between DBA and Developer [Fri, 16 Mar - 8 Posts] Separator in Mload [Mon, 20 Aug - 4 Posts] Serialize CLOB [Tue, 03 Jan - 2 Posts] Session in responding state [Thu, 13 Dec - 2 Posts] Sessions in PMON [Tue, 02 Oct - 2 Posts] SET ERRORLEVEL 3803 SEVERITY 0 - not working with GTT [Wed, 27 Jun - One Post] SET table with UPI [Fri, 30 Nov - 9 Posts] Shared nothing architecture for SMP and MPP [Wed, 18 Apr - 3 Posts] SHOW previlege [Fri, 06 Jul - 2 Posts] Slow changing dimension [Tue, 20 Mar - 3 Posts] Solutions to Data Skewing [Sat, 14 Jan - 4 Posts] Space occupied by blanks [Wed, 23 May - 4 Posts] Space Utilization report on a tabular format [Mon, 03 Dec - 2 Posts] Spaces in Varchar [Wed, 09 May - 2 Posts] Split the time into regular intervals [Fri, 30 Mar - 2 Posts] Spool Out when not using order by clause [Tue, 05 Jun - One Post] SPOOL Space for each logon id [Thu, 07 Jun - 3 Posts] SQL Assistant history file questions [Tue, 29 May - 3 Posts] SQL Assistant v 13.10.0.05 taking minutes to open [Thu, 25 Oct - 2 Posts] SQL Assistant Version 13 - Error 3932 [Thu, 30 Aug - 7 Posts] Start of Responding state [Thu, 05 Apr - 3 Posts] Starting view point through browser [Fri, 14 Dec - 9 Posts] Stop Ferret from supvr in Database Window [Fri, 28 Dec - 3 Posts] Store procedure update [Fri, 30 Mar - One Post] Stored Procedure: SELECT INTO clause [Fri, 05 Oct - 2 Posts] Re: Stored Procedures - Cursor Processing [Thu, 23 Feb - 14 Posts] Stress testing [Tue, 02 Oct - 4 Posts] String extraction in teradata [Thu, 12 Apr - 6 Posts] Substr from right on decimal number [Fri, 06 Apr - 3 Posts] Subtables for FLOAD [Thu, 15 Mar - 2 Posts] Subtraction between dates [Fri, 02 Nov - 8 Posts] Support for Windows 7 [Mon, 16 Apr - 5 Posts] Surrogate key is defined on the index column [Thu, 03 May - 2 Posts] SYSDBA password reset [Mon, 24 Sep - 6 Posts] System clock change [Tue, 25 Sep - One Post] SYSUDTLIB Access to Users [Wed, 26 Dec - 2 Posts] 
 
 Table Locking [Fri, 14 Sep - 2 Posts] Table skewed on load [Tue, 10 Jan - 2 Posts] Tables Data comparison [Wed, 06 Jun - 4 Posts] Tables left in load status [Fri, 24 Feb - 4 Posts] Tables not access/updated in past 90+ days [Wed, 04 Jul - 6 Posts] TASM Throttle [Fri, 01 Jun - 4 Posts] TBIO-OLAP cube issues [Fri, 23 Mar - One Post] TD 14: Metaphone [Thu, 06 Dec - One Post] TDWM Database version does not match the Teradata version for the system [Thu, 06 Dec - 6 Posts] Temp Space in Bteq [Thu, 02 Aug - 2 Posts] Tenacity and Fastload/Multiload [Thu, 07 Jun - 7 Posts] Teradata 12 Basic Certification help [Fri, 27 Jul - One Post] Teradata 13 certification [Fri, 11 May - 4 Posts] Teradata Alert for Database space [Tue, 02 Oct - 4 Posts] Teradata and Cloud computing [Wed, 28 Nov - One Post] Teradata Database hash fuction [Fri, 01 Jun - 2 Posts] Teradata Hashing and MD5 hashing for CDC [Tue, 10 Jul - 2 Posts] Teradata macro or sp to create the mload scripts [Tue, 07 Aug - 3 Posts] Teradata Manager Alert Setup questions [Fri, 23 Mar - One Post] Teradata Manager Setup email Alerts [Wed, 08 Aug - 4 Posts] Teradata Parallel Transporter Installation [Tue, 11 Dec - 13 Posts] Teradata Provided Scheduling Tools [Mon, 17 Dec - 6 Posts] Teradata reserved words by release [Tue, 01 May - 3 Posts] Teradata Resource Planning Guidlines [Wed, 19 Dec - 2 Posts] Teradata Security with Active Directory [Tue, 15 May - 2 Posts] Teradata Server Logs [Thu, 08 Nov - 4 Posts] Teradata Server Migration Without BAR [Fri, 12 Oct - 8 Posts] Teradata View point - Demo version [Fri, 11 May - 7 Posts] Teradata Viewpoint Portlets [Wed, 04 Apr - 10 Posts] Teradata Warehouse Builder [Fri, 07 Dec - 3 Posts] The string contains an untranslatable character. [Sun, 10 Jun - 3 Posts] Time out error with PPI [Wed, 30 May - 2 Posts] To create a journal table [Thu, 06 Sep - 2 Posts] To extract certain DATE-TIMESTAMP [Wed, 29 Feb - 4 Posts] To find the CPU Usage of the system [Mon, 13 Mar - 7 Posts] TPT - Filter condition. [Sun, 09 Dec - 2 Posts] TPT error: TPT 19404 pmopen failed [Sat, 21 Jul - One Post] TPT Exporter operator usage for pipe delimeter file. [Tue, 22 May - 3 Posts] TPT script: Query ends within a string or comment block [Mon, 09 Apr - 5 Posts] Tpump and Date Format [Sun, 18 Nov - 2 Posts] TPUMP DBS Wait Time [Tue, 20 Nov - One Post] Tpump jobs not getting logged in TPUMPSTATUS [Mon, 03 Dec - One Post] TPUMP running very very slow [Fri, 16 Nov - 4 Posts] Tracking DML operations in Teradata [Thu, 21 Jun - 5 Posts] Trail versions of Mload and FastLoad [Thu, 14 Jun - 2 Posts] Troubleshooting AMP CPU SKEW [Thu, 12 Apr - 8 Posts] Truncation of character string while insert [Sun, 16 Dec - 3 Posts] Trusted sessions setup help [Thu, 07 Jun - 2 Posts] TTU 13.1  & TTU14 on same server [Wed, 01 Aug - 3 Posts] TTU14 Assessment with TD13.10 [Mon, 05 Mar - 2 Posts] Two logon variables [Fri, 20 Jan - 6 Posts] 
 
 UDF to extract Varbyte to various formats [Fri, 06 Apr - 2 Posts] Unable to Login to TD Manager [Thu, 26 Jan - 5 Posts] Unblock a table [Mon, 27 Feb - 2 Posts] Unique index vs. primary index [Tue, 24 Jan - 5 Posts] Update fails but select works with same [Tue, 18 Sep - 3 Posts] Upgrade to sqla14 express [Mon, 12 Mar - 3 Posts] UPI with some columns combination and PI with 1 or 2 column [Tue, 17 Jul - 3 Posts] Use of Negative Values Instead of NULL [Thu, 19 Apr - 6 Posts] Use of Union with literals [Fri, 03 Feb - 9 Posts] User Information in Teradata [Fri, 24 Aug - 7 Posts] Users access not getting revoked! [Thu, 25 Oct - 2 Posts] Users Session limit change settings [Tue, 15 May - 2 Posts] Using a date variable in BTEQ [Tue, 19 Jun - 4 Posts] Using COPY command to copy tables [Thu, 02 Aug - 9 Posts] Using ErrorCode and ActivityCount within Bteq [Wed, 16 May - 9 Posts] Using Partition backup for multiple specific [Wed, 25 Jul - 3 Posts] Using QCD? [Fri, 20 Apr - 2 Posts] Using results returned from a Stored Procedure [Fri, 14 Dec - 3 Posts] 
 
 Valid trailing spaces in key values [Thu, 23 Feb - 3 Posts] VALUE IN a QUERY IS NOT valid [Thu, 01 Mar - 5 Posts] Varchar (255) VS varchar (256) in Teradata [Fri, 13 Apr - 2 Posts] Variable name for a new or existing table? [Tue, 24 Apr - 2 Posts] View point issue [Mon, 30 Jan - 11 Posts] View Point Server Root Password not working! [Tue, 28 Nov - 3 Posts] Viewpoint - TASM State matrix [Fri, 30 Nov - 5 Posts] Viewpoint Alert - Data collector Down [Sun, 26 Nov - 2 Posts] Viewpoint smtp test failed [Wed, 08 Feb - 4 Posts] ViewPoint Vs Teradata Multi Sytem Manger [Thu, 12 Jan - 2 Posts] VM player for Teradata express 13.10 VM [Thu, 29 Nov - 5 Posts] Volatile table in TD 13.10 [Mon, 10 Dec - One Post] Volatile tables within Stored Procedures [Tue, 03 Apr - 2 Posts] 
 
 What does COMMIT option and TRANSACTION flag [Wed, 18 Jul - 2 Posts] What does COMPRESS NULL actually do? [Fri, 27 Jan - 2 Posts] What does TOP actually mean? [Fri, 20 Jul - 8 Posts] What exactly a SESSION means? [Wed, 22 Aug - 7 Posts] What happens when a new node is added [Fri, 02 Nov - 7 Posts] What is a Change data capture (CDC) concept [Wed, 01 Aug - 2 Posts] What is column fieldstatistics in [Wed, 30 May - 4 Posts] What is difference between Sample 10 and Top 10? [Tue, 29 May - 7 Posts] What is Logon Source [Thu, 31 May - 5 Posts] What is Patition Ellimination [Mon, 19 Nov - 3 Posts] What is the difference between start/snowflake schema and Fsldm? [Fri, 27 Jul - 3 Posts] What is the purpose of PARTITION BY CASE_N [Mon, 09 Jan - 2 Posts] What is the use of LIKE operator for char fields [Wed, 14 Nov - 6 Posts] What is TPT [Mon, 19 Mar - 5 Posts] What makes an AMP go Down [Mon, 20 Aug - 5 Posts] What type of lock will apply for Collect stats [Mon, 01 Oct - One Post] What will happen is a vdisk is FULL [Thu, 01 Nov - 4 Posts] When to recollect stats? [Fri, 13 Jan - 3 Posts] Where NULL values will store while joining [Fri, 01 Jun - 3 Posts] Which has better performance? [Wed, 11 Jul - 2 Posts] Why a Query with Huge IN List Fails [Wed, 30 May - 4 Posts] Why does size of table increase in multiples of 512 bytes [Tue, 24 Jan - 11 Posts] Why IBM Mainframe giving MAx RC 4095 [Wed, 13 Jun - 2 Posts] Why incorrect stats are worse than not collecting stats? [Thu, 31 May - 7 Posts] Why would GROUP BY decrease spool [Tue, 01 May - One Post] |