| December, 2002 |
|
|||||||||||||
|
All articles have been reprinted with the written consent of their respective authors. | |||||||||||||
|
|||||||||||||
|
Freeware: Data Dictionary for
Oracle v1.1 Quest Software presents Data Dictionary for Oracle v1.1, a freeware tool for viewing DBA_View information. Use this application to reference Oracle 9.i2 documentation or connect to your own Oracle instance to obtain descriptions and column data from a live system. Click Here for more information and to download this tool. |
|||||||||||||
|
|||||||||||||
|
Using LDAP as an Oracle
Professional - Part I It often seems that new Oracle releases include features you’re not likely to use in the near future, like AQ, Oracle Wallet, iFS, analytics, etc. You make a mental note and move on. One new feature, LDAP integration, should not be dismissed so quickly. In this paper, we will look at how LDAP began, its best qualities, basic terminology, LDAP URLs, searches and filters, as well as where Oracle is headed with LDAP. In Part II, which will be featured in January, a case study is presented where the author converted a custom, table-based, web security framework to one using an LDAP directory server. Click Here for Part I of the paper.
|
|||||||||||||
|
|||||||||||||
|
Top Ten SQL Tuning Tips Structured Query Language (SQL) is the blessing and the curse of relational DBMSs. Since any data retrieved from a relational database requires SQL, this topic is relevant to anybody accessing a relational database; from the end user to the developer to the DBA. When efficient SQL is used, the results are highly scalable, flexible, and manageable systems. When inefficient SQL is used, response times are lengthy, programs run longer and application outages can occur. Considering that a typical database system spends 90% of the processing time just retrieving data from the database, it's easy to see how important it is to ensure your SQL is as efficient as possible. Checking for common SQL problems such as 'SELECT * FROM' is just the tip of the iceberg. In this paper, we'll explore other common SQL problems that are just as easy to fix. Bear in mind, a SQL statement can be written with many variations and result in the same data being returned -- there are no "Good" SELECT statements or "Bad" SELECT statements, just the "Appropriate for the Requirement." Each relational DBMS has its own way of optimizing and executing SELECT statements. Therefore, each DBMS has its own Top SELECT Performance Tips. This paper will focus on DB2 for OS/390 and z/0S, with examples and overview from Quest Software's Quest Central for DB2 product. Click
Here for the topic. |
|||||||||||||
|
|||||||||||||
|
Procedure to Count the Number of
Nulls Occurring in a Table This stored procedure generates an anonymous PL/SQL block that
calculates how many NULL values occur in each column for all rows of
the given table. It returns a string of the form
"col1,cnt1,col2,cnt,...,colN,cntN" where colN is the
column name and cntN is the number of NULL values found for the
column. It also displays the entire anonymous block so you can
see what it is doing. Click Here for the procedure. Procedure to Print the Difference Between Two
Date Values This stored procedure prints the absolute
difference between two DATE values in hours-minutes-secs. It
can also be turned into a function to return the string instead of
printing it through dbms_output. Click Here
for the procedure.
|
|||||||||||||
|
|||||||||||||
|
Microsoft T-SQL
Performance Tuning - Part 4 This article is the fourth in a series that describes a variety of performance tuning techniques that you can apply to your Microsoft SQL Server Transact-SQL programs. In many cases, you could use the graphic user interface provided in the Microsoft tools to achieve the same or similar results to those described here. For example, the graphic SHOWPLAN feature of SQL Query Analyzer will show you the query plan for a query. However, this series focuses on using Transact-SQL commands as the basis for our solutions. All examples and syntax are verified for Microsoft SQL Server 2000. These articles illustrate, through examples and explain plans, useful techniques for improving queries in Microsoft SQL Server 2000. There are a number of small tips and techniques applicable in narrow classes of programming tasks. Knowing them expands your resources in performance optimization. We have chosen to use Microsoft SHOWPLAN_ALL output in all examples in this section, because they are more compact and still show all the critical information. Click
Here for the paper. |
|||||||||||||
|
|||||||||||||
In a large project, all communication takes place in context of an overall communications strategy and plan. Status meetings and status reporting are required, just as for a medium size project. In addition, there are many other types of proactive communication that need to be considered. This creative and proactive communication is laid out in a Communication Plan. Click Here for tips and techniques on
Communication Plans. |
|||||||||||||
|
|||||||||||||
| Free
e-Seminars For detailed information on these free e-Seminars, please visit our News and Events page.
|
|||||||||||||
|
|||||||||||||
|
|||||||||||||
|
|||||||||||||
|
Interactive Crossword
Puzzle: "Name That Face"
|
|||||||||||||
|
|||||||||||||
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, we will mail you a FREE gift from Quest as a gesture or our appreciation. 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. It is currently circulated to 28,000 readers. 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 send a note to unsubscribe@quest-pipelines.com and we will make every effort to remove you from our list. 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 |
|||||||||||||
