|
|
 Blogs
Toad World blogs are a mix of insightful how-tos from Quest experts as well as their commentary on experiences with new database technologies. Have some views of your own to share? Post your comments! Note: Comments are restricted to registered Toad World users.
 Do you have a topic that you'd like discussed? We'd love to hear from you. Send us your idea for a blog topic.
By Bert (User) on
Tuesday, November 23, 2010 10:43 AM
I’ve written several blogs over the past couple years on how to speed up TOAD when its screens or utilities seem to take minutes instead of seconds. In many cases (i.e. Oracle versions 10.X and 11.X), the case is often that the DBA is not manually collecting statistics on the data dictionary – that many believe that Oracle does this all “Auto-Magically” for them. And as you can see in those various blogs – it does not. ...
|
By e0aba78c-c04c-4ee1-a696-90b499bc5cc8 on
Tuesday, November 23, 2010 5:58 AM
This blog is the eighth in a series about misconceptions surrounding SQL tuning that are quite common.
|
By 362dce9c-a552-4b5b-ac95-ab109db9f2a6 on
Tuesday, November 23, 2010
We are pleased to announce availability of the final beta release (build 575) of Code Tester version 2. We currently plan to release Code Tester 2.0 in January 2011. This is a feature-complete beta; while the Help documentation is still being finished up, all features present in this build will be available in the production release of Code Tester 2.0.
Key features of Code Tester 2.0:
Redesigned main window:...
|
By 7a7dcd3c-0d79-4d4c-859e-60cc2161339d on
11/19/2010 1:00 PM
All too often I see sites with far too many concurrent manager processes and the site wonders why they have intermittent performance issues. Remember, having more concurrent manager processes does not mean more throughput.
|
By ce4e6745-3fec-406d-b3e5-5aa35edbc5fd on
11/17/2010
Load testing is an interesting topic. Application load testing is what most people are familiar with. They either use something like LoadRunner, or they ask half the company to ‘jump on the website and start clicking buttons.’
But what about the database? In this case, what about SQL Server? Will it be able to sustain the workload as it increases? Will the performance SLAs hold? Does the average response time for a transaction increase at a predictable rate as the user load goes up?
|
By a33eae33-0bda-4a72-817d-7f62e5f5cdcc on
Monday, November 15, 2010
Two years ago, I wrote the first blog on how to setup Toad’s Team Coding utility to use the Subversion Version Control System (VCS). That was when we were about to launch Toad version 9.7 – seems like a long time ago!
Today, we have Toad version 10.6 and things have changed slightly. We no longer depend on any 3rd party SCC plug-ins in order to use Subversion in Toad (actually this has been the case since 10.5). Also, we have aligned VCS support in Toad so it makes no difference whether or not you want to use Team Coding; file-based version control supports the same VCS providers
|
By StevenFeuersteinTW (User) on
Monday, November 08, 2010 2:44 PM
I love to hear from PL/SQL developers, and I love to help them out, but sometimes I am just too busy to respond quickly or in time. But sometimes, best of all, a developer asks me for help, and then solves his or her problem without my help.
That happened last week, and the result is a utility that I thought I would share with you. I received this email from Bryan Nyman (bnyman1@yahoo.com):
" apologize...
|
By ce4e6745-3fec-406d-b3e5-5aa35edbc5fd on
11/8/2010
For most couples, ‘date night’ is something to look forward to, but unfortunately does not come around often enough. For others, even the word ‘date’ sends a chill down their spine. It’s not an adverse reaction to their partner, but rather a unpleasant reminder to the daily toil that is working with DATE formatted data in their relational database.
|
By 7a7dcd3c-0d79-4d4c-859e-60cc2161339d on
11/6/2010 11:03 AM
The site in presented with over 30 million rows in the fnd_logins table, growing at a rate of approximately 25,000 records per day. Even holding 31 days of history on-line I would have expected no more than 800,000 rows in the table.
How did this happen when the site was running the sign-on audit purge program Purge Signon Audit data (FNDSCPRG) daily
This case review reviews how this could happens and how I would go about addressing the issue
|
By e0aba78c-c04c-4ee1-a696-90b499bc5cc8 on
Friday, November 05, 2010 8:01 AM
I have been asked many times how to use one source SQL statement and tune it for different sized databases. The problem is that when you have only one program source and you want to deploy it to various sized databases in different companies, it is quite common that the SQL performs well in company A but performs poorly in company B. If you tune the SQL for company B, the new SQL syntax and plan may not be good for...
|
By ce4e6745-3fec-406d-b3e5-5aa35edbc5fd on
11/5/2010
A better title might be ‘Tools are Too Cool for School’ or ‘If you don’t use Tools You are Dumber Than a Caveman’ or…well, you get the idea I think.
|
By BBoise (User) on
11/2/2010
If you’ve ever used the Code Snippets feature, in Toad for Data Analysts, you may have found the list to be, well, rather robust. The solution provides snippets for the majority of database platforms supported by the solution (DB2 LUW, DB2 z/OS, SQL Server, Oracle, MySQL, Sybase, and ODBC). Why do I want to view snippets for DB2 when I’m working with a SQL Server database? Good question.
It appears that the latest...
|
By StevenFeuersteinTW (User) on
Monday, November 01, 2010 8:35 AM
I received this request from Jayme last week:
"Hello Steven. In Transact-SQL I was able to have a block of code say if today was a Monday give me Friday's date, else give me yesterday. I have no idea how to do this in PL/SQL and you said if you spend more than 30 minutes on a problem to get a second set of eyes to look at it...will you be my second set of eyes?"
We needed logic similar to this for the PL/SQL...
|
|
|