#DateForumTypeThreadPost
2602 Feb 2011 @ 08:02 PSTAnalyticsTopicRow counts for every table in a given databaseIs there a macro or stored procedure anywhere that gives row counts for every table in a given database?
2530 Jun 2010 @ 06:05 PDTToolsTopicSQL Assistant completely disappears when user attempts to log onOne of my users is experiencing a problem while attempting to connect to our development environment via SQL Assistant. SQL Assistant opens up, and he clicks on the 'CONNECT' button. He then sel...
2423 Sep 2009 @ 11:12 PDTDatabaseTopicData usage benchmarks to identify most used vs least used dataI need to establish some set of data usage benchmarks to identify most used vs least used data, in terms of recency of use and frequency of use. Are there any Teradata macros available to determine...
2316 Sep 2009 @ 01:41 PDTAnalyticsTopicTeradata SQL Assistant result setI am performing some stress tests of user queries, and the query text contains carriage returns. When I try to put this data in an Excel spreadsheet, it breaks up the query text. I tried checking...
2212 Mar 2009 @ 02:39 PDTUDATopicNew AccessRights AbbreviationWe recently upgraded our QA and Dev systems to 6.2.2.64 and are now seeing an accessright that is not on our production box, which is at 6.2.2.55. We are seeing an accessright value of 'G'.Can a...
2130 Apr 2008 @ 01:36 PDTUDATopicStripping unknown charactersHow can I, in a select statement, strip "garbage" characters from a column in my result set? For example, we have a table that was loaded by another application, and some of the values contain wha...
2028 Apr 2008 @ 09:45 PDTUDAReplyCascading RolesI was afraid of that. I couldn't find it anywhere in the documentation or in white papers, I was just hoping....I know how to generate the SQL, it's just very, very time consuming with the number ...
1917 Apr 2008 @ 11:25 PDTDatabaseTopicCascading rolesI would like to know if there is a way to automatically grant a role to a child. If UserA owns UserB, UserC, and UserD, I would like to be able to grant role_basic_rights to UserA and have that rig...
1817 Apr 2008 @ 10:56 PDTUDATopicCascading RolesI would like to know if there is a way to automatically grant a role to a child. If UserA owns UserB, UserC, and UserD, I would like to be able to grant role_basic_rights to UserA and have that ri...
1701 Feb 2008 @ 03:15 PSTUDAReplyDisappearing Access RightsThank you both for your responses.As the DBA, I did not revoke any privileges (direct or role-related ). I did read something about nested roles having a problem, but that also is not the case in ...
1630 Jan 2008 @ 02:00 PSTUDATopicDisappearing Access RightsWe had an issue where a user received a 3523 error (The user does not have EXECUTE access...)when attempting to execute a macro that the same user executes several times on a daily basis.Has anyone...
1523 Oct 2007 @ 02:12 PDTDatabaseReplyData DictionaryNever mind on this one. I found the information I need and the column is in dbc.indices.
1423 Oct 2007 @ 01:23 PDTDatabaseReplyData DictionaryThank you very much for the response. Is there also a column in dbc.tvm that indicates whether or not the table has a partitioned primary index defined?
1318 Sep 2007 @ 02:29 PDTDatabaseTopicData DictionaryIs there any table/view in the data dictionary that we can query to find out if a table is a multiset table, a set table, a global temp table, etc.?
1218 Sep 2007 @ 10:45 PDTDatabaseTopicPartition EliminationWe have encountered a situation where using different phrasing in the WHERE clause of the select causes the optimizer to react differently.When BETWEEN is used in the WHERE clause, the explain plan...
1130 Jul 2007 @ 11:06 PDTToolsReplyUpgrade to V2R6If you have implemented PPI, I would test any queries against those tables. Also, save your before and after explain plans...that could be helpful if issues arise.
1011 May 2007 @ 01:51 PDTToolsReplymissing comments in viewsAll comments are retained with TTU 8.2
911 May 2007 @ 01:47 PDTToolsReplyMissing recordsI have never worked with Informatica, so I am not sure what those logs do for you. But since you didn't find anything there, maybe you should query the two error tables that you create at the begi...
811 May 2007 @ 11:37 PDTToolsReplyMissing recordsWhere did you check for the missing records? Did you query your error tables?
711 May 2007 @ 11:23 PDTToolsTopicMultiLoad and the check constraintWill multiload work on tables that have the check constraint defined on columns?
611 May 2007 @ 10:51 PDTUDATopicMultiLoad and the Check ConstraintWill multiload work on tables that have the check constraint defined on columns?
510 May 2007 @ 01:48 PDTUDAReplyValid column values in conjunction with default valueThank you so much!
410 May 2007 @ 10:28 PDTUDATopicValid column values in conjunction with default valueCan you put a default value on a column as well as a list of "valid values"?
313 Mar 2007 @ 01:16 PDTUDAReplyOdd Error when attempting to create a macroThe problem was that I had the statement to set my database right before the 'create macro' statement. Thanks for looking at it!
213 Mar 2007 @ 07:25 PDTUDAReplyOdd Error when attempting to create a macroFYI - this macro was created in our test system; I'm getting this error when I try to create it in the production environment...explainREPLACE MACRO GCR_M_V50_LIST_KEY_STYLES(DIVN_NBR INTEGER, SUPE...

Pages