|
August, 2003
In
This Issue
|
|
All articles have been reprinted with the written consent of their respective authors. | |||||||||||||
|
|||||||||||||
|
How to: Create a Data Mart or Data
Warehouse Time Dimension A datamart or data warehouse will usually need a time dimension to use for date queries that look at periods, weeks, etc. Here is an example of how to generate one from the basic date entry and the Oracle date functions. The same idea can be used in DB2, Informix, Postgresql, etc. Click Here
for the script. |
|||||||||||||
|
|||||||||||||
|
So You Want to Use Oracle's SPFILE Oracle's traditional method of storing parameters in the INIT.ORA file has given way to a more robust method-- the server parameter file (SPFILE). Learn what truly works in converting and maintaining your parameters without ever having to use an editor again. Click Here
for the article. |
|||||||||||||
|
|||||||||||||
|
Debugging Stored Procedures on
UNIX and Windows The support for SQL Procedures implemented in DB2 UDB allows you to remotely debug stored procedures executing on the DB2 UDB server. The remote debug is already available for Java stored procedures. However, at the time of writing this redbook, remote debugging for SQL stored procedures (and C/C++) was still being developed, so we could not test this support. In this section, we describe the steps required to remotely debug SQL stored procedures executing on a DB2 UDB server, based on the steps required for 444 Cross-Platform DB2 Stored Procedures: Building and Debugging debugging Java stored procedures. Note that since we did not have the final version of the product, these steps may be different when the support for SQL Procedures is available. Click
Here for the paper. |
|||||||||||||
|
|||||||||||||
|
Identify and Delete
Duplicate Data from a Table Recently I was asked to
help someone clean up their database after they had double loaded an
import file. The problem they were having in identifying and
deleting the duplicate information was the fact that a timestamp is
applied to each row of data as it is inserted into the table. While
the rest of the row of data was duplicated, the timestamp made the
row unique. It was this uniqueness that caused the simple methods of
determining and deleting duplicate data to fail. They needed a way
to delete data from a table in which they determine the criteria of
what made the data duplicate. Click
Here for the article. |
|||||||||||||
|
|||||||||||||
For the most part, the days of the hundred million dollar project are over. Very large projects are simply too difficult to manage and execute successfully. There are a number of problems with very large projects. Click Here
for tips and techniques on how to Break Large Projects into Smaller
Pieces. |
|||||||||||||
|
|||||||||||||
|
Free Webcasts
|
|||||||||||||
|
|||||||||||||
|
|||||||||||||
|
|||||||||||||
|
Interactive Crossword
Puzzle: "Quotable Movies II"
|
|||||||||||||
|
|||||||||||||
|
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 |
|||||||||||||
