#DateWhereItemComment
1711 Feb 2016 @ 06:51 PSTcarrie's blogTeradata Basics: ParallelismHi Carrie, late reading but learning much, thank you for this article. About multi-statement you said "any sub-expressions that the different SQL statements have in common will be executed o...
1610 Sep 2015 @ 05:55 PDTcarrie's blogHow Resources are Shared in the SLES 11 Priority SchedulerHi Carrie, very interesting and clear ! can you help me to make the good relation between Workloard group assignment to Timeshare levels and Priority inherited from a PROFILE definition of Account...
1519 Aug 2015 @ 02:31 PDTcarrie's blogRequest Cache Hits & MissesCarrie, After investigation i read some interesting details about Cache management structure in documentation (Teradata SQL Reference). Sorry for questions "in a hurry", Pierre
1419 Aug 2015 @ 12:38 PDTcarrie's blogRequest Cache Hits & MissesCarrie, by the way, how does the optimizer recognize a "query" as being already in cache from another query being not ? I understand that every query is marked as an entry in the query ...
1317 Aug 2015 @ 09:24 PDTcarrie's blogRequest Cache Hits & MissesHi Carrie, i come back in the discussion to ask for possible updates (V15 and UDA too ...): About those modifications of dictionary objects - table, column, table header, stats - that have the ...
1205 Mar 2015 @ 02:53 PSTcarrie's blogNew, Simplified Approach to Parsing Workload SelectionCarrie, I do agree on everything about rows/requests considerations. About Session WDID and WDID of the request i can't say that they often differ, just it happens on some users. About ident...
1102 Mar 2015 @ 07:32 PSTcarrie's blogNew, Simplified Approach to Parsing Workload SelectionHi Carrie, assuming that DBQLOGTBL captures the whole logging of the activity, what is the proven rule to distinguish session rows with a specific parsing WDID ? everytime SessionWDID is differen...
1023 Jan 2015 @ 06:17 PSTtomnolan's blogThe Teradata JDBC Driver's COP Discovery, LCC, Logon, and moreHi Tom, such a lightening paper is nice everytime ! So, can we say that COP discovery is not a mandatory step for a JDBC connection and COP = OFF leads to a DNS lookup ? what about the connectio...
926 Aug 2014 @ 02:49 PDTViewpointTeradata Viewpoint 15.00 Release ArticleHo yes ! it would be very very helpful, avoiding to ramble through windows to retrieve roles and portlets and permissions ... Pierre
825 Jul 2014 @ 12:56 PDTViewpointTeradata Data Lab and Viewpoint 14.0 releasesThanks Gary, I do agree with you about modifying rights. this being said, all of those rights in place are available for users in datalabs belonging to Labgroups: how to deal to afford some user...
723 Jul 2014 @ 01:07 PDTViewpointTeradata Data Lab and Viewpoint 14.0 releasesGary, i'm discovering Labgroups (V14.10) : it looks like a standard set of rights were prepared at Labgroup level, except DELETE (?), and available at the Labgroup creation time. I can't ...
623 Jun 2014 @ 01:40 PDTcarrie's blogMore on ResUsageSAWT When Collection and Logging Rates DifferCarrie, what about AWT analysis in V14.10 ? CollectIntervals column does not exist any longer, so i wonder wether another column is superseding the old one, or the difference between Log Time an...
511 Dec 2013 @ 07:18 PSTToolsTeradata Studio's Copy Objects via Drag and DropHi, continuing testing STUDIO COPY TABLE i got a successful copy from PROD to DEV system with a bypass: 1) create target table T1 on "DEV" (STUDIO DDL window, changing name T to T1 ...
411 Dec 2013 @ 01:59 PSTToolsTeradata Studio's Copy Objects via Drag and DropHello, I experiment some difficulties to copy a table from PROD system to DEV system (1 GO Table):  - COPY is beginning and stopped due to USI and NUSI on source table: "Cannot load ta...
327 Mar 2013 @ 07:44 PDTToolsTeradata Studio products - choosing the right client toolHi ! i can't download Teradata Studio on my PC, due to site control policy ... therefore i could download TTU from TAYS some weeks ago. Why Teradata Studio should not be avalaible on TA...
211 May 2011 @ 10:03 PDTToolsWhat’s new in Teradata SQL Assistant 13.11Thanks ! it's OK (the button in V13.11 is better). About Teradata.Net, i am interested in reading some documentation on why and what for choose it vs ODBC ? Pierre
111 May 2011 @ 06:48 PDTToolsWhat’s new in Teradata SQL Assistant 13.11Great ! at the moment i use SQLA V13.00 and i just tried Macros .... how to delete a recorded Macro ? Thanks for help, Pierre