#DateForumTypeThreadPost
3909 May 2016 @ 12:38 PDTDatabaseReplyJoining varchar to integerHi all, sorry for being away. I changed the structure of the smaller table by modifying the PI as well as changing the joining PI columns to VARCHAR. Hence the condition became a simple PI - PI jo...
3804 Apr 2016 @ 02:34 PDTDatabaseReplyJoining varchar to integerHi Dieter, Will definitely try the things suggested. Can't do much about the data model though... :( The actual query does not have the "top 10". I just added it to check if the pro...
3703 Apr 2016 @ 09:42 PDTDatabaseReplyJoining varchar to integerBump...
3631 Mar 2016 @ 07:58 PDTDatabaseTopicJoining varchar to integerHi all, I am trying to tune a query that quickly spools out during a join on two tables between varchar and integer value. This is the query I am running: SELECT top 10  A.* ...
3515 Sep 2015 @ 05:40 PDTDatabaseReplyHow do I make an exact copy of a current tableThere are two ways to approach this.  If you are about to create the table copy, you should go with the syntax mentioned above: Create Table DatabaseName.Table_Copy as DatabaseName.Table ...
3411 Aug 2014 @ 04:11 PDTDatabaseReplyData backupBelow is the difference between the two: Restore Job: If the table you are to restore currently exists at the same location, (note that it has not been dropped and recreated since the time the ...
3323 Sep 2013 @ 05:55 PDTViewpointTopicQueries used by Data CollectorsHi All, I know that the Data Collectors in Viewpoint get the data from the DBQL tables, is there any way to get the queries that are actually used so that I can have a better understanding of wh...
3218 Sep 2013 @ 12:52 PDTDatabaseReplyDifference Between Restore Job and Copy JobHi Amolph, During the time of FastLoad or MultiLoad some tables having extensions (‘ET_’, ‘UV_’, ‘WT_’, ‘LT_’) are created in the database duri...
3115 Sep 2013 @ 11:58 PDTDatabaseReplyDifference Between Restore Job and Copy JobBelow is the difference between the two: Restore Job: If the table you are to restore currently exists at the same location, (note that it has not been dropped and recreated since the time the ba...
3015 Sep 2013 @ 11:13 PDTDatabaseReplyquery for getting elapsed timeRajgopal,  The above query will give you the total time the query spent on the system (including active time and delay time). If you want to calculate the total Active Execution Time of the q...
2915 Sep 2013 @ 11:06 PDTDatabaseReplyCalculating the actual query run timeTo find the total time the query spent on the system vs the total time the query was actuallly processed can be found via dbql:   ( ( a.firstresptime - a.starttime  ) HOUR( 4 ) &n...
2815 Sep 2013 @ 09:16 PDTDatabaseReplyGet Row Count of a Table on a previous dateThanks for the replies folks. We have a housekeeping job that keeps a record of all the sizes of tables as well as databases, but only 90 days old.
2710 Sep 2013 @ 09:59 PDTDatabaseTopicGet Row Count of a Table on a previous dateHi All, We keep 3 months of historic data. Is it possible to get the row count of a table on any previous date? The date might be 1,2 or 3 months old. I can get the size of the table but is the...
2608 Sep 2013 @ 10:35 PDTViewpointReplyRelease Query in Delayed StateThe following is the solution: "For Teradata Database systems, you can release a query from the delay queue for immediate processing." Now in my case, the qeury was executing a &qu...
2508 Sep 2013 @ 10:11 PDTViewpointTopicRelease Query in Delayed StateHi All, In the "Query Monitor" portlet there is a column for sessions in the Delayed Sate. If I release any query that is in the Delayed state, what will happen? Will the query be rele...
2402 Sep 2013 @ 06:14 PDTDatabaseReplyHow Can User Change Password?Thanks Dieter, This solves it then. 
2328 Aug 2013 @ 09:39 PDTDatabaseTopicHow Can User Change Password?Hi All, For a user to be able to change a password of his own user or another user, he must have "Drop User" access on that particular user. Yesterday, however, a user (and I have reche...
2225 Aug 2013 @ 09:40 PDTViewpointReplyTASM Exception and TASM FiltersHello Teraforsk, The "Elapsed Time" criteria is the total time which the query was present on the system. Like I said, it is the sum of the time the query was in delayed state because of...
2115 Jul 2013 @ 04:29 PDTViewpointTopicTASM Exception and TASM FiltersHello all, Is there any way in TASM to set up an exception to abort queries based on the time in which they are in "acive state"? For example, if a query is in delayed state for half an...
2015 Jul 2013 @ 04:27 PDTGeneralReplyTASM Filters and ExceptionsHello all, Is there any way in TASM to set up an exception to abort queries based on the time in which they are in "acive state"? For example, if a query is in delayed state for half an...
1914 Jul 2013 @ 11:37 PDTDatabaseReplyHow to Calculate the total IO used by System for a particular weekThanks Dnoeth, I'll check it out and will get back to you on this. Cheers
1809 Jul 2013 @ 02:59 PDTDatabaseReplyHow to Calculate the total IO used by System for a particular weekAny reply on the above?
1709 Jul 2013 @ 02:57 PDTDatabaseTopicFull Table ScansHi All,   I would like to know where the information is about queries performing Full Table Scans or using Index Scans. If you could share the query that would be really great. This would re...
1606 Jul 2013 @ 07:39 PDTDatabaseTopicHow to Calculate the total IO used by System for a particular weekHi Everyone, The last week was a very busy one on my project. I saw AWTs being consistently used in the range of 60-70. I have calculated the CPU Utilization for the time period mentioned. The cli...
1510 May 2013 @ 12:53 PDTDatabaseReplyHow to assign rights of existing user to a newly created user?Thanks Harpreet, I understand this query will give me any direct rights the user has on a specific database as well the rights held by a user through roles on a particular database. This is what I...

Pages