17 | 11 Feb 2016 @ 06:51 PST | carrie's blog | Teradata Basics: Parallelism | Hi 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... |
16 | 10 Sep 2015 @ 05:55 PDT | carrie's blog | How Resources are Shared in the SLES 11 Priority Scheduler | Hi 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... |
15 | 19 Aug 2015 @ 02:31 PDT | carrie's blog | Request Cache Hits & Misses | Carrie,
After investigation i read some interesting details about Cache management structure in documentation (Teradata SQL Reference).
Sorry for questions "in a hurry",
Pierre
|
14 | 19 Aug 2015 @ 12:38 PDT | carrie's blog | Request Cache Hits & Misses | Carrie,
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 ... |
13 | 17 Aug 2015 @ 09:24 PDT | carrie's blog | Request Cache Hits & Misses | Hi 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 ... |
12 | 05 Mar 2015 @ 02:53 PST | carrie's blog | New, Simplified Approach to Parsing Workload Selection | Carrie,
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... |
11 | 02 Mar 2015 @ 07:32 PST | carrie's blog | New, Simplified Approach to Parsing Workload Selection | Hi 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... |
10 | 23 Jan 2015 @ 06:17 PST | tomnolan's blog | The Teradata JDBC Driver's COP Discovery, LCC, Logon, and more | Hi 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... |
9 | 26 Aug 2014 @ 02:49 PDT | Viewpoint | Teradata Viewpoint 15.00 Release Article | Ho yes !
it would be very very helpful, avoiding to ramble through windows to retrieve roles and portlets and permissions ...
Pierre
|
8 | 25 Jul 2014 @ 12:56 PDT | Viewpoint | Teradata Data Lab and Viewpoint 14.0 releases | Thanks 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... |
7 | 23 Jul 2014 @ 01:07 PDT | Viewpoint | Teradata Data Lab and Viewpoint 14.0 releases | Gary,
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 ... |
6 | 23 Jun 2014 @ 01:40 PDT | carrie's blog | More on ResUsageSAWT When Collection and Logging Rates Differ | Carrie,
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... |
5 | 11 Dec 2013 @ 07:18 PST | Tools | Teradata Studio's Copy Objects via Drag and Drop | Hi,
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 ... |
4 | 11 Dec 2013 @ 01:59 PST | Tools | Teradata Studio's Copy Objects via Drag and Drop | Hello,
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... |
3 | 27 Mar 2013 @ 07:44 PDT | Tools | Teradata Studio products - choosing the right client tool | Hi !
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... |
2 | 11 May 2011 @ 10:03 PDT | Tools | What’s new in Teradata SQL Assistant 13.11 | Thanks !
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 |
1 | 11 May 2011 @ 06:48 PDT | Tools | What’s new in Teradata SQL Assistant 13.11 | Great !
at the moment i use SQLA V13.00 and i just tried Macros ....
how to delete a recorded Macro ?
Thanks for help,
Pierre |