#DateForumTypeThreadPost
1823 May 2011 @ 09:01 PDTDatabaseTopicColumn order in table definition when collecting multi-column statisticsI know that the first 16 bytes of a column(s) are what is used in the histogram when collecting stats on a table. I also know that when collecting stats on 2 columns, and the first column is more t...
1731 Jan 2011 @ 06:47 PSTDatabaseReplyTABLE SIZEI know you said the DDL was identical but might want to check for fallback between the two environments.
1627 Jan 2011 @ 01:37 PSTDatabaseTopicTeradata Manager ReadOnly usersI would like to establish readonly connections into the Teradata Manager service on my Teradata Manager server. I have set up a profile called READONLY with access to session information only. ...
1529 Dec 2010 @ 11:19 PSTDatabaseReplyConvert varchar(8) to date in select statementThanks NetFx... upon further examination, I found 00000000 values in the column which was causing the error.
1429 Dec 2010 @ 10:56 PSTDatabaseReplyConvert varchar(8) to date in select statementThe source data column is coming in as '19981001' (yyyymmdd). When I run the following SQL I get the same error: 2666: Invalid date supplied for tablename.columnname Select cast(columnnames ...
1329 Dec 2010 @ 09:58 PSTDatabaseTopicConvert varchar(8) to date in select statementI would like to convert a varchar(8) field to a date field in a select statement. I have tried a number of different statements and non of them seem to work. For the statements that I think shoul...
1222 Nov 2010 @ 11:30 PSTDatabaseTopicSysDBA admin rights cloneI want to create a user with the exact same permissions as sysdba. What is the simplest method for achieving this? Thanks!
1101 Sep 2010 @ 08:27 PDTDatabaseReplyDifferent between soft referential integrity and hard referential integritySoft RI also enables the use of a join index when only a subset of the tables are used in the query.... same concept as above.
1001 Sep 2010 @ 08:22 PDTDatabaseReplyDuplicate Unique Prime key error in Identity column TableYou may want to check the max(identity col) value against the avail_value using the following query: SELECT dbase.DatabaseName, tvm.TVMName AS TableName, tvfields.FieldName AS ColumnName, tv...
901 Sep 2010 @ 07:00 PDTDatabaseTopicCalling all Teradata DBAs - Question around drop table grants.I'm posting this to solicit input from fellow Teradata DBAs concerning when to grant CT/DT privledges to a Teradata user in a produciton database. In my particular situation, I have set up a user ...
813 Jul 2010 @ 07:41 PDTDatabaseTopicRecollect stats by database after patch upgrade rollbackDoes anyone out there have some dynamic sql that will script stats collection from a PROD database to be applied to a TEST database? We had to rollback a patch upgrade and I lost all my stats in t...
711 May 2010 @ 12:21 PDTDatabaseReplyMerge Join with OVERLAPS producing huge spool fileThe main thrust of this query is to merge three tables together (one is aliased) giving a total of four tables, LOADS DUMPS HAULS with a fourth table OPS_EQUIP_STATE to identify a date ...
611 May 2010 @ 12:06 PDTDatabaseTopicMerge Join with OVERLAPS producing huge spool fileCalling all 'OVERLAPS' function experts...Does anyone understand why the overlaps function below is blowing a 1million and 57million spool file merge join out to 23billion rows? The problem lies...
505 May 2010 @ 02:41 PDTDatabaseReplyMTJI self joinsthanks Dieter... you are the man! I also got a response from Teradata on this limitation. They are going to allow self joins in the creation of a join index in a future release... don't know if i...
429 Apr 2010 @ 04:53 PDTDatabaseTopicMTJI self joinsDoes anybody have a way to create a join index that includes table aliases in the join index definition? For example: CREATE JOIN INDEX JI_TABLE_ALIASES, NO FALLBACK, CHECKSUM = DEFAULT AS SE...
329 Apr 2010 @ 10:19 PDTDatabaseReplySequences (again)One alternative is to use an identity column (defined as a bigint) on the staging table. From there, the value is moved into your EDW without the restrictions placed on an identity column (trigger...
231 Mar 2010 @ 05:13 PDTDatabaseTopicConverting data and time to timestampWhen I run the following, the date portion of the timestamp is always the previous day. SELECT CAST(CURRENT_DATE AS TIMESTAMP(0)) + ((CURRENT_TIME - TIME '00:00:00') HOUR TO SECOND(0)); Anybo...
131 Mar 2010 @ 05:09 PDTDatabaseReplyCreate Timestamp from Date and TimeWhen I run the following the date portion of the timestamp is always the previous day. SELECT CAST(CURRENT_DATE AS TIMESTAMP(0)) + ((CURRENT_TIME - TIME '00:00:00') HOUR TO SECOND(0)); Anybod...

Pages