SEARCHDATABASE.COM | Database Administrator Tips June 18, 2003 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FROM OUR SPONSOR:
Quick Guide to Windows Server 2003 http://searchDatabase.com/r/0,,15308,00.htm?microsoft =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - SQL Server: Find duplicate indexes - Oracle: A shell script to archive and clean your alert log - DB2: Indexing text extenders to improve performance - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Ask the experts: Your database questions answered - Featured Topic: Help for database newbies ___________________________________________________________________ ******************** Sponsored by Microsoft *********************** The Quick Guide to Windows Server 2003. Get the latest information on installation, new features and training. Click here! http://searchDatabase.com/r/0,,15308,00.htm?microsoft ******************************************************************* ___________________________________________________________________ THIS WEEK'S TIPS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FIND DUPLICATE INDEXES | Preethiviraj Kulasingham Two SQL Server 2000 user-defined functions that return duplicate indexes on the current database. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci903835,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SHELL SCRIPT TO ARCHIVE AND CLEAN YOUR ALERT LOG | Richard Murnane Here is a quick Unix shell script you can use to archive and clean your Oracle alert log. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci905861,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= INDEXING TEXT EXTENDERS TO IMPROVE PERFORMANCE | Susan Lawson Author Susan Lawson discusses how to index text extenders to improve DB2 performance. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci906870,00.html ___________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: UPGRADING SQL SERVER, PART II: CRITICAL UPGRADE DECISIONS http://www.searchDatabase.com/tip/1,289483,sid13_gci904447,00.html Jeremy Kadlec continues his series detailing the SQL Server upgrade process from the technical, logistical and business perspective. This time, he discusses SQL Server 6.5 to 2000 critical upgrade decisions and redundant upgrade architecture. FIND FULL TABLE SCANS | Sanjay Gupta http://www.searchDatabase.com/tip/1,289483,sid13_gci893666,00.html This tip is useful for identifying all full table scans (FTS) occuring in your Oracle database. Doing a FTS on big tables often causes performance problems. There are many tools available that allow you to select a SQL statement and then present you with the SQL plan; however, when you have thousands of SQL statements and you want to find out only those statements that are going through a FTS, this is a better script. MULTIPLE SORTS WITHOUT USING DYNAMIC SQL | Jim Haire http://www.searchDatabase.com/tip/1,289483,sid13_gci903834,00.html Have you ever wanted the order of your DB2 data sorted differently based on some condition? You could do it by coding multiple cursors or creating dynamic SQL. Here is a way to do it with static SQL and only one cursor. PL/SQL CONTROL STRUCTURES: BEST PRACTICES | Steven Feuerstein http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci904096,00.html Here are several best practices you should take into account when you work with IF, FOR, WHILE, and GOTO statements in PL/SQL. Hundreds more free tech tips submitted by members: http://searchdatabase.techtarget.com/tips/0,289484,sid13_tax281808,00.html Share your knowledge, submit a tip, win a prize: http://searchdatabase.techtarget.com/tipsSubmit/1,289485,sid13,00.html ___________________________________________________________________ IMPORTANT LINKS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= YOUR TOUGH DATABASE QUESTIONS ANSWERED | Ask the Experts Oracle: Separating object into two schemas in same instance http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid536703_tax289342,00.html Oracle: Where are RMAN scripts kept? http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid536827_tax289342,00.html SQL Server: Performance impact of partitioning table http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid536694_tax285648,00.html Oracle: Updating an open cursor http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid535988_tax289342,00.html Oracle: When to use functions and stored procedures http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid535991_tax289342,00.html More expert answers here: http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= HELP FOR DATABASE NEWBIES | SearchDatabase.com Featured Topic To newbies, the modern DBMS is impossibly complex. They're right, of course! Inside is a wealth of resources for those just starting out: tips, webcasts, advice and much more. >> CLICK for our current Featured Topic... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci817960,00.html >> CLICK for previous Featured Topics... http://searchdatabase.techtarget.com/featuredTopics/0,290043,sid13,00.html ___________________________________________________________________ *********************SEARCHDATABASE CONTACTS*********************** TIM DICHIARA, Site Editor (mailto:[EMAIL PROTECTED]) >> Send your feedback and original articles. SARA CUSHMAN, Assistant Editor (mailto:[EMAIL PROTECTED]) >> Send your White Papers and favorite Web sites. ELLEN O'BRIEN, News Editor (mailto:[EMAIL PROTECTED]) >> Send your product announcements and poll ideas. TOM CLICK, Sales (mailto:[EMAIL PROTECTED]) >> Sponsor this or any other TechTarget newsletter. ___________________________________________________________________ **********************ABOUT THIS NEWSLETTER************************ Created by TechTarget (http://www.techtarget.com) TechTarget - The Most Targeted IT Media Copyright 2003, All Rights Reserved. ___________________________________________________________________ :::::::::::::::::::: ABOUT THIS NEWSLETTER ::::::::::::::::::::: Published by TechTarget (http://www.techtarget.com) TechTarget - The Most Targeted IT Media Copyright 2003, All Rights Reserved. To unsubscribe from 'DBA Tips,' simply reply to this e-mail with REMOVE (all caps) within the Body or Subject or go to http://searchDatabase.techtarget.com/register, log in to edit your profile, click on the link to Edit email subscriptions, and uncheck the box next to the newsletter you wish to unsubscribe from. When finished, click "Save Changes to My Profile."
