#DateForumTypeThreadPost
44830 Apr 2013 @ 12:59 PDTDatabaseReplySecondary indexesAlso, SI will have some (may be very minor) performance impact as well while loading of data.
44729 Apr 2013 @ 06:06 PDTDatabaseReplySecondary indexesIts not about view or query .... rather it more relates to the use of the table in question. How the table is going to be accessed? Which columns will be used in joins? What type of queries are to ...
44625 Apr 2013 @ 10:24 PDTDatabaseReplyAggregate Operations with Case Specific dataPlease share your query for getting the SUM.   Ideally it should return seperate SUM values for Aa and AA.   Also, share the DDL of the table you are doing SUM on, are the columns def...
44525 Apr 2013 @ 10:14 PDTDatabaseReplyFULL PRIMARY INDEXFull primary index is .... as Dieter said .... combination of all PI columns.   Every statement .... INSERT, UPDATE or DELETE .... does use PI in one way or another .... but you dont have to...
44424 Apr 2013 @ 08:44 PDTData ModelingReplyConverting Rows to ColumnsIs it one-time activity? or going to be a continous process?
44324 Apr 2013 @ 08:16 PDTDatabaseReplySecondary indexesWhich ETL tool you are using? Either you can do that in pre-SQL/post-SQL .... or have a combined script from dropping and loading SIs .... or even better option is to use TPT, if possible.   ...
44224 Apr 2013 @ 04:48 PDTDatabaseReplyDivision by zero ErrorTry:   SELECT AVG(C2) .... if it fails .... open an incident .... if it doesnt .... its not coz of AVG.
44124 Apr 2013 @ 04:46 PDTDatabaseReplyTeradata ViewpointMay be a refreshing issue .... 
44024 Apr 2013 @ 04:44 PDTPrivate Forum
43924 Apr 2013 @ 04:42 PDTPrivate Forum
43824 Apr 2013 @ 04:40 PDTDatabaseReplyThere is another way to remove a volatile table?What do you mean my removing a VT from SP? As in VT stays created after SP is executed? Or you want to remove the usage of VT from SP?
43724 Apr 2013 @ 04:38 PDTDatabaseReplyCheck for special character in a stringFirst you need to define 'special characters' and then you need to use them in LIKE statement.   Example:   SELECT * FROM Table1 WHERE Col1 LIKE ANY ('%/%', '%.%&#...
43603 Apr 2013 @ 04:55 PDTDatabaseReplyselecting values from a table where max value is nullSelecting with COALESCE(COL1,CURRENT_DATE)= COALESCE(MAX(COL1),CURRENT_DATE) is best option.
43503 Apr 2013 @ 04:43 PDTDatabaseReplyBest way to generate the Sequential numbers : CSUM or IDENTITY columns?Depends on the questions asked by Dieter.   Based on that, you can use:   IDENTITY SUM(1) OVER(ROWS UNBOUNDED PRECEDING) ROW_NUMBER RANK ....
43403 Apr 2013 @ 04:40 PDTDatabaseReplyStored Procedure Vs BteqFew coming in my mind would be ....   BTEQ script: Simplistic conditional logic No exception handling Runs on CLI connection No concept of parameters   SP: Complex conditional lo...
43318 Mar 2013 @ 01:55 PDTTeradata ApplicationsReplyHow to optimize the query? The Explain plan is given below. Its showing no more spool space.Whats the skewnes of underlying tables?
43218 Mar 2013 @ 01:50 PDTToolsReplyNeed of Collect StatisticsCollection of unnessasary stats does have a downside, but considering your scenario, it shouldnt be an issue.   Moverover, it is always an evolving thing to come up with the best possible st...
43118 Mar 2013 @ 01:33 PDTDatabaseReplyCan we access a table from SQL UDF in TD 14?For the correct way o implement that .... again .... What will be the use of this fuction?
43018 Mar 2013 @ 01:24 PDTUDAReplyIssue during Conversion of varchar to Timestamp(0)Sample data would help .... but it seems to be a FORMAT issue.
42918 Mar 2013 @ 01:19 PDTDatabaseReplyData From Vendor ChangesThe scenario requires a complete documentation on the format of the file and possible cases to cater for. What is seems is the example of complex structured file containing interrelated data in sep...
42818 Mar 2013 @ 01:17 PDTDatabaseReplyStats collection inside SP'sBEGIN and END period data-types are the specific types that Temporal table uses to manage history.   HTH!
42717 Mar 2013 @ 11:05 PDTDatabaseReplyGRANT/REVOKE LOGON TO ROLE ?GRANT/REVOKE LOGON only takes user as an input, not the role. May be you can package the commands in a script for ease of use.   HTH!
42611 Mar 2013 @ 02:38 PDTDatabaseReplyWill volatile tables be dropped?We had an implementation where VTs were being created in dynamic-SQL .... and after some update patch installation same SPs running for months started to fail. On investigation we had to do followi...
42511 Mar 2013 @ 02:29 PDTPrivate Forum
42411 Mar 2013 @ 02:18 PDTGeneralReplyAMP - Storing the RecordIn such a scenario .... one should think before choosing a PI.   It is not a bug of Teradata .... it just doesn't expect a PI to be a column which have only 2 unique values .... imagine ...

Pages