|
August, 2004
In
This Issue
|
|
All articles have been reprinted with the written consent of their respective authors. | ||||||||||||||||
|
||||||||||||||||
|
DateADD This function will return a new date value based on adding an interval to the specified date. Click here
for the script. |
||||||||||||||||
|
||||||||||||||||
|
Supercharging the Pump
New import and export features introduced in Oracle Database 10g, called Oracle Data Pump, represent a radical departure from the client/server approach to which database users have grown accustomed over the past several generations of Oracle Database. The server now runs export and import jobs. You can load or unload massive amounts of data quickly using parallelization, and you can adjust the degree of parallelism on the fly. Export and import jobs are now restartable, so a failure doesn't necessarily mean starting over. The API is exposed and easy to use; it's simple to create an import or export job from PL/SQL. And once started, such jobs run in the background, but you can check status and make modifications, from anywhere, using the client utilities. Click here for the article.
Note: This article was previously published on OTN
.
| ||||||||||||||||
|
||||||||||||||||
|
Effective Indexes for Data Warehouses Creating the right indexes to boost performance is an art. These guidelines will help you master the process. Indexes are important objects in a relational database. With effective indexes, complex queries run much faster than they would with less optimal indexes. But query performance depends less on how many indexes exist on the tables than on what kind of indexes exist. Figuring out how to create the most effective indexes is a big challenge. Click here
for the article. |
||||||||||||||||
|
||||||||||||||||
|
Improving PL/SQL Performance By Using Collections Yesterday I looked at some code written in Oracle
7-style PL/SQL, and compared it with what is considered best practice with
Oracle 8i and 9i. The more up-to-date code generally runs around 3-5 times
faster than the old style code, and, as part of understanding where the changes
to PL/SQL have occurred, I've started off by looking at how Oracle now handles a
concept known as 'Collections'.
Click
here
for the article. |
||||||||||||||||
|
||||||||||||||||
|
Freeware: Toad for SQL Server & Toad for MySQL
Quest now offers freeware tools for MySQL and SQL
Server developers and database administrators. With the knowledge and success
gained from our past experience with TOAD® for Oracle, we’ve created
Toad® for MySQL – Preview Release and Toad® for SQL Server.
Developers and database administrators alike can use a familiar tool that improves
productivity by providing an easy-to-use development environment to manage MySQL and
SQL Server databases. As with TOAD, Quest equips you with the ability to create and
execute queries, automate database object management and create both SQL Code and
T-SQL code more efficiently with an intuitive graphical interface.
|
||||||||||||||||
|
||||||||||||||||
One of the ways to recognize uncertainty in your estimates is to add in a contingency factor. The
contingency is increased or decreased based on the level of uncertainty you have in your estimate.
For most small and medium sized projects adding a reasonable estimating contingency is perfectly
fine and should give you a final estimate that you can reasonably expect to achieve.
For larger projects, however, there are more powerful techniques available for recognizing the estimating risk. The most common is the Monte Carlo model. Monte Carlo is a modeling technique that takes into account the level of uncertainty you have in estimating each activity in your workplan. Click here
for more information on Monte Carlo modeling. | ||||||||||||||||
|
||||||||||||||||
|
Free Webcasts |
||||||||||||||||
|
||||||||||||||||
|
||||||||||||||||
|
||||||||||||||||
|
Interactive Crossword
Puzzle: "Olympics"
|
||||||||||||||||
|
||||||||||||||||
|
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 |
||||||||||||||||
