|
Super & Sub Type Option #1 |
|
Bert
|
Friday, November 30, 2007 3:50 PM
|
|
|
|
When we create a super-and-sub type (a.k.a. Inheritance) entity relationship in a logical data model, it’s very clear what the business requirements being communicated are – that different subsets of attributes comprise the “cumulative entity” being modeled depending upon the business context. &l ...
|
 |
|
Comments (3)
|
Read More...
|
|
|
|
My Favorite Templates – in one convenient file |
|
StevenFeuersteinTW
|
11/28/2007 1:24 PM
|
|
|
|
Would you like to increase productivity, improve code quality, and ensure that standards are being followed? Of course you would! And one of the best ways to do that is to rely heavily on Toad's Code Templates (similar functionality exists in SQL Navigator as well).
|
|
|
|
Comments (1)
|
Read More...
|
|
|
Multi-Location Script Executions |
|
JimWankowski
|
Wednesday, November 21, 2007 8:24 PM
|
|
|
|
In many cases there is a need to create an object or to execute an SQL statement in multiple locations. The group execute option in TOAD for DB2 allows you to execute a script against multiple environments with one easy step.&nb ...
|
|
|
|
Comments (1)
|
Read More...
|
|
|
Questions I hear over and over and over… |
|
JeffSmith
|
Tuesday, November 20, 2007 10:38 PM
|
|
|
|
I have worn many different hats here at Quest, and recently put on another in the Sales organization. Regardless of what my official title has been, talking to our Toad customers has always been one of the most rewarding aspects of my career. I decided a long time ago that I would do all I could to master Toad and share my findings with others. I hope to ne ...
|
|
|
|
Comments (0)
|
Read More...
|
|
|
Oracle 11g on a notebook: Tread Lightly |
|
Bert
|
Friday, November 16, 2007 10:41 AM
|
|
|
|
This blog posting is not meant to demean or slander the Oracle database in anyway. I’ve staked almost my entire career on Oracle technologies – and I intend to finish these last 7-10 years doing more Oracle stuff. To quote a funny Saturday Night Live skit: “Oracle has been very, very good to me.” So my comments are mo ...
|
|
|
|
Comments (0)
|
Read More...
|
|
|
|
Expedite Saving Data via Toad |
|
Bert
|
Tuesday, November 06, 2007 8:14 AM
|
|
|
|
Probably one of the most useful and frequented tasks performed with Toad® for Oracle is saving data to a file, such as comma delimited text (or any of the other numerous formats supported). It’s a relatively easy feature to find – you simply depress the “right hand mouse” (RHM) ...
|
|
|
|
Comments (4)
|
Read More...
|
|
|
Oracle Parallel Query Abuse |
|
Bert
|
Wednesday, October 31, 2007 6:46 AM
|
|
|
|
Oracle’s Parallel Query Option (PQO) is a fantastic tool, but much like any good tool, it can very easily be used in the wrong situation or simply abused. In those cases, PQO can actually make database performance much worse. Let’s examine some common misuses or misperceptions regarding optimal and efficient PQO usage.
|
|
|
|
Comments (0)
|
Read More...
|
|
|
TheThree Letter Word |
|
JimWankowski
|
Monday, October 29, 2007 2:27 PM
|
|
|
|
I just got back from the IBM IOD conference in Las Vegas; it was a great show. Every year there is usually some buzz about what is “hot” with DB2. This year’s buzz was heard loud and clear – XML was being discus ...
|
|
|
|
Comments (0)
|
Read More...
|
|