#DateForumTypeThreadPost
1010 Mar 2014 @ 04:59 PDTDatabaseReplyJoin Issues - Need help in most efficient way to solve the problemAlthough 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...
912 Feb 2014 @ 03:42 PSTDatabaseReplyDatabase Hierarchiesdbc.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. ...
828 Jan 2014 @ 11:36 PSTDatabaseReplyGet query metadata without running itI 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...
728 Jan 2014 @ 11:27 PSTDatabaseReplyGet query metadata without running itBrilliant!   Thanks
628 Jan 2014 @ 10:07 PSTDatabaseReplyGet query metadata without running itFred, 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 ...
528 Jan 2014 @ 09:19 PSTDatabaseReplyGenerate SurrogateKey with a huge tableHow 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...
428 Jan 2014 @ 06:41 PSTDatabaseReplyGet query metadata without running itHello 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...
327 Jan 2014 @ 04:00 PSTDatabaseTopicGet query metadata without running itIf 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 ...
231 Oct 2013 @ 08:58 PDTTeradata StudioTopicResult set viewer and SQL history viewI 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...
123 Apr 2013 @ 01:48 PDTTeradata StudioReplyTeradata Eclipse Plug-in 14.02 does not load in Mac version of Eclipse EE Juno R2I 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.

Pages