|
January, 2006
In
This Issue
|
|
All articles have been reprinted with the written consent of their respective authors. | ||||||||||||||||
|
||||||||||||||||
|
Upgrading to Oracle 10g With Minimal Downtime By Lenka Vanek & Tom Chu, Quest Software Upgrading hardware is usually painless, but upgrading databases…well, everyone has a horror story to tell. The primary concerns of a seasoned Oracle DBA are the success of the upgrade and the downtime that could result. Success being not only that the upgrade itself worked properly, but more importantly, that production applications run flawlessly on the upgraded database. In this paper, we will provide suggestions for minimizing downtime and risk of failure by using a proven process and technology.
Click here
for the article. | ||||||||||||||||
|
||||||||||||||||
|
Insights Into PL/SQL Integers
When it comes to declaring and manipulating integers, Oracle offers
lots of options, including. These include INTEGER,
BINARY_INTEGER, PLS_INTEGER, POSITIVE, NATURAL, and SIGNTYPE.
The question that immediately comes to my mind is: how much of a
difference in performance does the choice of datatype make in my
program? I put together a script to analyze precisely that: the
integer_compare script set.
It comes in two flavors: integer_compare.sql, which can used in
Oracle Database 10g (relies on DBMS_UTILITY.GET_CPU_TIME to compute
elapsed time) and integer_compare_pre_10g.sql, which can used in
versions earlier than Oracle Database 10g (relies on
DBMS_UTILITY.GET_TIME to compute elapsed time).
Click here for more. |
||||||||||||||||
|
||||||||||||||||
|
SQL Full-Text Search - A Brief Overview SQL Full-Text Search (FTS) allows users to conduct rapid searches against textual content stored in databases. These searches are an order of magnitude faster than if you were using a LIKE statement, and they can be done against content which is stored in its native format (i.e. a Word or PDF document stored in columns of the Image or VarBinary data type). The search is actually conducted against an index (stored in the file system) which contains pointers for each word to the table and rows which contain this word. This index is built asynchronously by an indexing engine called MSFTESQL. SQL FTS also has rich language features which allow natural language searching in a multitude of languages. This allows you to search on all forms of a word. For example, for a noun like book searches will match with book, books, or book's and for a verb like book searches will match with book, books, booked, booking, etc. The language features also captures language rules for a variety of non Western languages such as Chinese, Japanese, Thai, and Korean. Click Here for the article.
In A Nutshell
Interested in learning more tips and techniques for SQL Server? "In A Nutshell"
is what you are looking for. Kevin Kline,
author of O'Reilly's "SQL in a Nutshell" and "Transact-SQL Programming" and President of The Professional Association for SQL Server,
offers tips, techniques and much more. Updated numerous times a week,
there is always valuable material to be had!
Click
here
to see what Kevin is up to in the SQL Server world. | ||||||||||||||||
|
||||||||||||||||
One of the basic responsibilities of the project manager is to assign work to team members. However, some project managers are not always clear on the work to be done and the person that is responsible. This causes uncertainty in the team and can result of some activities running late. In fact, if you have managed projects for a while, you have probably run into this situation. You might ask a team member the status of a critical assignment and they may tell you that they did not realize that they were assigned to the activity. A good way to test whether your directions and assignments are clear is to ask team members what they are responsible for completing in the next two weeks. This is not something you need to do with every team member every week. However, it can be valuable to ask once in a while, or when a critical activity is due, just to validate whether you are assigning activities clearly. If the team members know what is expected of them, chances are that you are effectively and clearly assigning the work. However, if team members give you different answers than you expect, it may mean that you need to work on being clearer and more precise. Click here for more information on team member assignments. | ||||||||||||||||
|
||||||||||||||||
|
Webcasts
| ||||||||||||||||
|
||||||||||||||||
|
||||||||||||||||
|
||||||||||||||||
|
Interactive Crossword
Puzzle: "Famous Firsts"
|
||||||||||||||||
|
||||||||||||||||
|
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 |
||||||||||||||||
