Recent comments
SQL Assistant 13.0 - Enhancements and Differences
| Attachment | Size |
|---|---|
 SQLA13_0528.pdf | 558.9 KB |
 SQLA13_0528.ppt | 630.5 KB |
This presentation describes the new features introduced in SQL Assistant 13.0 and points out the similarities and differences between this and previous versions.
SQL Assistant 13.0 is an entirely new application that has been re-designed from the ground up. It has been designed to look and act very much like previous versions of the product, by default, but it now uses the Microsoft .Net Framework rather than Visual Basic 6.
There are now many more options, and features, and a few things have changed a little.
This presentation will help those who have used the application in the past make a smooth transition to the new version.
The presentation is available in 2 formats. Select the one that best matches your requirements:
Nice read about the changes. I like that you touch on the bad sides as well. Performance has hit our shop hard and really feels like at big step back. Hoping for a better release down the road. We are the geeks who would rather trade the fancy office look for speedy startup and grand history file =)
Where and when can I get it :) ?
Teradata SQL Assistant 13.00.00.05 is available for download from the "Teradata At Your Service" site.
Are there any plans for a platform independent solution based on Java and JDBC (similar to Oracle's SQL Developer) to be offered eventually?
Mike, I know that you mentioned in the PDF and presentation that the new SQL Assitant would use more memory and it would startup slower, but on my machine which unfortunately is probably more memory starved and process starved that it should be, it takes roughly 20 seconds for it to start up and there seems to be a slight lag time when closing answerset windows and even in opening the answerset when the data is being returned. Are there things in progress to somehow speed some of this up? It also seems to have some issues with re-drawing itself if behind other windows and then brought to the front. Now again this could be to my system running low on resources. Just curious mainly cause when I roll this out to my users, I am sure to get a lot of people complaining about the slowness.
I think there is going to be a java query tool at some point but I dont know how much of the same functionality it will have, or how soon it will be released.
20 seconds is very slow if this is NOT the first time you started it after booting up, but the first time after booting your pc it could take up to about 40 sec on an older or low memory pc.
Something else that will slow it down is if you have a large number of history rows and you have not applied a filter. Previous versions loaded only the first 'n' rows (which masked the slow start) but the new one requires you to set a "most recent 'n' days" filter to provide a similar limit.
Also make sure you have the latest version - 13.0.0.5 since there were improvements added.
Teradata SQL Assistant Java Edition 13.01 is available for those looking for a platform independent alternative. See "http://developer.teradata.com/tools/articles/sql-assistant-java-edition-13-01-available" for details.
It is not completely equivalent with SQL Assistant (but it's catching up real fast) and the Java team would love to hear what features you want to see in it.
Mike, I have a very strange issue. I am on Terdata SQL Assistance 13.11.0.03, database version Teradata 12.00.0321 12.00.03.21, ODBC 13.10.00.06. When I execute a query the Answerset window returns the data back very slow. Other developers can run the same query and the result set back in seconds. I have uninstalled teradata twice and still have the same issue. Any assistance would be great. Example, I select a table that only has 234 rows, after 7 minutes it had only returned 20 rows of the 234 rows.
Iris
The only thing I can think of is that you have some kind of tracing/debugging switched on.
If the debugging as at the interface level switching from ODBC to Teradata.Net (or vise versa) would probably fix the problem - and identify the tracing that needs to be turned off.
The only other explaination I can think of would be some kind of network problem where most of the network packets are failing and have to be re-sent. (unlikely)
hi mike... i am using teradat version 14 and facing some issues. hope you could help me out.
1st issue: whenener i run any query in teradata, columns having data typ CHAR or VARCHAR coming blank. showing no data.
2nd issue: when i use select query option by clicking 'generate sql' on table under database explorer, query having columns coming with double quotes. how to remove those dowuble quotes so that i can run the quiery directly after generating SQL.
PLEASE HELP ME OUT
Adding the double quotes around names is an option on the DBTree tab.
You don't need to remove them though. Teradata accepts double quoted names - it is the only way to define a name if you use certain characters in that name.
I heard of the 'blank' CHAR column issue once before but I dont remember what caused it. I suspect it was related to the session character set.
Send me the details [Exact version, ODBC or Teradata.Net connection, character set, locale, etc.] at mike.dempsey@teradata.com.