| 10 | 10 Mar 2014 @ 04:59 PDT | Database | Reply | Join Issues - Need help in most efficient way to solve the problem | Although this is an interesting problem, but I would agree with Dieter in that, this is more of an algorithmic efficiency problem than data access efficiency problem. At 1000x300, your entire probl... |
| 9 | 12 Feb 2014 @ 03:42 PST | Database | Reply | Database Hierarchies | dbc.ChildrenV will certainly be the most straightforward way, but if you are also looking for a lillte challenge, then try this :) This will give you indented list showing you DB hierarchy.
... |
| 8 | 28 Jan 2014 @ 11:36 PST | Database | Reply | Get query metadata without running it | I just realized there is a minor flaw in all of these solutions. They won't work if the query has an un-aliased expression in SELECT caluse. For example following doesn't work.
hel... |
| 7 | 28 Jan 2014 @ 11:27 PST | Database | Reply | Get query metadata without running it | Brilliant!
Thanks
|
| 6 | 28 Jan 2014 @ 10:07 PST | Database | Reply | Get query metadata without running it | Fred, that would have been an excellent suggestion, but unfortunately, I am using Python as scripting language. Python's DB API implementation (pyodbc) doesn't expose ODBC's SQLPrepare ... |
| 5 | 28 Jan 2014 @ 09:19 PST | Database | Reply | Generate SurrogateKey with a huge table | How about storing the max value in a separate table instead of calculating every time?
For example, let table sk_seed have two columns (tablename varchar(128), next_sk bigint) with tablename being... |
| 4 | 28 Jan 2014 @ 06:41 PST | Database | Reply | Get query metadata without running it | Hello Raja,
Thanks for your response and sorry if my question was a bit confusing. What I wanted was, "given an arbitrary SQL statement, how would I find out number and types of colum... |
| 3 | 27 Jan 2014 @ 04:00 PST | Database | Topic | Get query metadata without running it | If I have a SQL (select type) query, how would I find out properties of the resultset columns without actually running it? For example, if I were to crerate a view "V" using my query SQL ... |
| 2 | 31 Oct 2013 @ 08:58 PDT | Teradata Studio | Topic | Result set viewer and SQL history view | I couldn't find preferences that were obvious to me, so a few quick questions. How do I
get resultset viewer to display numbers right-aligned?
reuse the same result-tab for a spec... |
| 1 | 23 Apr 2013 @ 01:48 PDT | Teradata Studio | Reply | Teradata Eclipse Plug-in 14.02 does not load in Mac version of Eclipse EE Juno R2 | I ran into this issue as well today. Is the fix expected within a week or so? I'd rather not go back to Juno SR1 and instead wait for the fix to be available.
|