|
December , 2004
In
This Issue
|
|
All articles have been reprinted with the written consent of their respective authors. | ||||||||||||||||
|
||||||||||||||||
|
Number to Words This script converts numbers to their English equivalent and returns it as a string. Click here
for the script. |
||||||||||||||||
|
||||||||||||||||
|
Creating A Cascade Update Set of Tables
Many times we have the situation where a master table may be updated and dependent tables are left without a link back to the master. In this situation a cascade update option would be a nice one to have. Unfortunately Oracle Corp. doesn't provide this capability in a native manner so a PL/SQL option must be developed.
An example of a need for a cascade update would be in the situation where a dependent table could be dependent on one or more tables. For example, there may be two types of customer, one who has bought from us and we have marketing information for and another that is new to us, may buy from us, but may go with another vendor. If there are dependent tables (such as an interaction log that tracks phone calls to and from customers) it would be nice to be able to switch the dependencies from our new customer table to our established customer table.
Click here
for the article. "The Fellowship of the Toad"
"The Fellowship of the Toad" is an exclusive organization
through Quest Software with
privileges available to our members. The benefits of this free
program include: Click here to learn more and join "The Fellowship of the Toad"!! | ||||||||||||||||
|
||||||||||||||||
|
Taking High Availability Higher IBM zSeries servers, otherwise known as mainframe computers, have a reputation
as highly available systems — a reputation earned through four decades of
rock-solid reliability. DB2 for z/OS is an important part of the zSeries availability story. In this
column, I'll describe some of the things that the company I work for, CheckFree
Corp., has done to make a highly available system even more so. Click here
for the article. |
||||||||||||||||
|
||||||||||||||||
|
Identifying External or Internal Table Fragmentation This article describes how to identify tables that are fragmented internally (i.e., fragmentation inside data pages) or externally (i.e., extents are fragmented). The process of doing a DBCC re-index of a large database can be a time-consuming task. In most cases the fragmentation occurs in just a part of the database and is concentrated in just a few tables. Re-indexing just those tables should be sufficient and thus precious time and computer resources can be saved. Click here for the article.As the winner of the 2004 Microsoft Global ISV of the Year award, we'd like to make you aware of some exciting free training opportunities! Starting in January 2005, Microsoft will deliver a fast-paced week of training with at least 15 free WebCasts and, following, at least 1 WebCast per week focusing on specific developer topics for SQL Server 2005. Go to http://msdn.microsoft.com/SQL/2005Webcasts for all the details. Everyone who attends a WebCast will receive a copy of the SQL Server 2005 Beta 2 Resource Kit and the Beta 3 Resource Kit when it ships. Also, the first 1500 people that watch 5 or more WebCasts will also receive a special, limited edition SQL Server 2005 WebCast T-shirt. Additionally, all WebCast viewers will be entered into a competition to win an XBOX, one for each day of the week. (see http://msdn.microsoft.com/SQL/WebcastRules.aspx) |
||||||||||||||||
|
||||||||||||||||
The project approach is a section in the Project Definition that describes in words the thinking that goes into the creation of the Project Workplan. This information is for the benefit of the client and stakeholders who will not be able to easily interpret the actual workplan. Click here
for more information the project approach. | ||||||||||||||||
|
||||||||||||||||
|
Free Webcasts
| ||||||||||||||||
|
||||||||||||||||
|
||||||||||||||||
|
||||||||||||||||
|
Interactive Crossword
Puzzle: "D" Words
|
||||||||||||||||
|
||||||||||||||||
|
We love getting white papers, tips, articles, and code examples/archives from our readers around the world. Send your submission to newsletter@quest-pipelines.com. If your article is published, it will be mailed to over 28,000 subscribers. Our mission at Quest Software - RevealNet Labs is to anticipate the daily responsibilities and challenges faced by database professionals. Our products help thousands of people solve problems and implement solutions every day. This newsletter is designed to help facilitate the sharing of information among database professionals. About the Newsletter This newsletter is distributed to Quest Software - RevealNet Labs customers, prospects and friends who have subscribed to it from our website. If you would like to unsubscribe, please visit http://qlist01.quest.com/UnsubMailingList/ Subscribe a Friend! Do you know someone who would like to receive the Pipeline Newsletter? If so, please enter their email address in the box below and click SUBMIT.
Past Issues of the Pipeline Newsletter |
||||||||||||||||
