|
February, 2005
In
This Issue
|
|
All articles have been reprinted with the written consent of their respective authors.
| ||||||||||||||||
|
||||||||||||||||
|
Report on Redo Log Contention This script is used to report on overall redo log contention for the instance since the instance was last started. Click here
for the script. |
||||||||||||||||
|
||||||||||||||||
|
Doing More With More The latest release of DB2 Universal Database is brimming with features that make life easier for developers and DBAs alike. DB2 Universal Database (UDB) for Linux, Unix, and Windows v.8.2 (initially known by its codename, "Stinger") continues to deliver on IBM's promise of self-configuring, self-optimizing, and self-managing database management capabilities. In fact, with more than 100 new and improved features, DB2 UDB v.8.2 should prove to be the most significant point release of this product. DB2 UDB v.8.2 offers features that significantly increase productivity of database administrators and developers and meet complex data management requirements. For example, improvements to stored procedures provide developers with more flexibility to solve complex business processing challenges, while reducing database administration tasks at the same time. I'll present an overview of the many new and improved features packed into this release. Click here
for the article. |
||||||||||||||||
|
||||||||||||||||
|
Explain Plan's AUTOTRACE Facility
The EXPLAIN PLAN command is not the only way to see an execution plan for a given SQL statement. SQL*Plus includes the AUTOTRACE facility. The problem with the EXPLAIN PLAN command is that the EXPLAIN PLAN statement has to be explicitly run for the query you want to examine, then the plan table has to be queried. Once done, the information may be removed from the plan table before the process is repeated. The AUTOTRACE facility is an easier way to accomplish the same goal. The AUTOTRACE facility is only available in SQL*Plus. Unlike the EXPLAIN PLAN command, the AUTOTRACE facility must use a table called PLAN_TABLE. The EXPLAIN PLAN command can use a plan table of any name. The PLAN_TABLE table can be created with the ORACLE_HOME/rdbms/admin/utlxplan.sql supplied script. Additionally, before starting the AUTOTRACE facility, you must have been granted the PLUSTRACE role. This role is created with the ORACLE_HOME/sqlplus/admin/plustrce.sql supplied script.
Click Here to read more on the AUTOTRACE facility. |
||||||||||||||||
|
||||||||||||||||
|
Use SET STATISTICS IO and SET STATISTICS TIME to Help Tune Your SQL Server Queries This is not an article on how to tune queries (that subject would take a book), but an article on how to use the often overlooked Transact-SQL SET STATISTICS IO and the SET STATISTICS TIME commands to help us tune our queries. On the surface, the goal of performance tuning a query seems simple enough. Essentially, we want our queries to run faster. Whether it is trimming a query that takes 10 minutes down to 1 minute, or trimming a 2 second query down to 1 second, our ultimate goal is to reduce how long it takes our queries to run. 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) | ||||||||||||||||
|
||||||||||||||||
|
Procedural Programming in MySQL - Part
2 In the first part of Procedural Programming in MySQL published in last January’s Pipelines newsletter we looked at the basics of creating functions and procedures within MySQL. We looked at functions, procedures, parameters, variables and finally at the Select Into syntax. The first release of Stored Procedures within
MySQL set a base level of functionality that should suit most basic programming
requirements, but that’s not to say all of the standard features of a
programming language are not present. In this second part we will be looking at
the features of the language we didn’t cover in the first part. We won’t be
looking explicitly at how to code these features as that would require much more
space and time than we have here, but at the end you will have an understanding
of what’s available to you.
Click Here for the paper. | ||||||||||||||||
|
||||||||||||||||
One of the characteristics of a
project is that there is a definite start and end date. This seems simple
enough until you start to try to define exactly what these dates mean. There
are no universally recommended standards for either date. In many respects, it
depends on each organization and whether there are any implications for
choosing one alternative over another. There are a number of potential events
that could signify the project end date. Two definitions come up often, but
don’t really help settle the fundamental question.
Click here
for more information | ||||||||||||||||
|
||||||||||||||||
|
Free Webcasts
| ||||||||||||||||
|
||||||||||||||||
|
||||||||||||||||
|
||||||||||||||||
|
Interactive Crossword
Puzzle: 90's Trivia
|
||||||||||||||||
|
||||||||||||||||
|
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 |
||||||||||||||||
