SEARCHDATABASE.COM | Database Administrator Tips June 25, 2003 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FROM OUR SPONSOR:
Quick Guide to Windows Server 2003 http://searchDatabase.com/r/0,,15479,00.htm?microsoft =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - SQL Server: Split delimiter-separated lists - Oracle: Hot backup under Unix - DB2: Top 20 DB2 performance myths - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Ask the experts: Your database questions answered - Featured Topic: Availability and clustering ___________________________________________________________________ ******************** 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,,15479,00.htm?microsoft ******************************************************************* ___________________________________________________________________ THIS WEEK'S TIPS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SPLIT DELIMITER-SEPARATED LISTS | Andrew Novick Creating and parsing lists of items in a string is a frequently needed task. Here's a SQL Server UDF that shows you how to do it. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci911718,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= HOT BACKUP UNDER UNIX | Rajendra Gutta Rajendra Gutta continues his series of quality backup and recovery scripts for Oracle on Unix. Includes checklists and troubleshooting tips as well. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci911717,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= TOP 20 DB2 PERFORMANCE MYTHS | Richard A. Yevich & Susan Lawson Think you know DB2 performance tuning? Think again! Yevich and Lawson debunk some commonly-held beliefs about DB2 performance. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci910646,00.html ___________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: FIND DUPLICATE INDEXES | Preethiviraj Kulasingham http://www.searchDatabase.com/tip/1,289483,sid13_gci903835,00.html Two SQL Server 2000 user-defined functions that return duplicate indexes on the current database. SHELL SCRIPT TO ARCHIVE AND CLEAN YOUR ALERT LOG | Richard Murnane http://www.searchDatabase.com/tip/1,289483,sid13_gci905861,00.html Here is a quick Unix shell script you can use to archive and clean your Oracle alert log. INDEXING TEXT EXTENDERS TO IMPROVE PERFORMANCE | Susan Lawson http://www.searchDatabase.com/tip/1,289483,sid13_gci906870,00.html Author Susan Lawson discusses how to index text extenders to improve DB2 performance. ORACLE BACKUP AND RECOVERY SCRIPTS, PART I: COLD BACKUP UNDER UNIX http://www.searchDatabase.com/tip/1,289483,sid13_gci910648,00.html Rajendra Gutta's definitive cold backup and recovery scripts for Oracle running under Sun Solaris, HP-UX and AIX. GET THE DATABASE STARTUP TIME | Harish Kapgate http://www.searchDatabase.com/tip/1,289483,sid13_gci903836,00.html Use this quick SQL query to get the Oracle database startup date and time. 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 DB2: Comparison of SQL Server 2000 with OS/390 DB2 http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid537736_tax285651,00.html Oracle: Security holes opened by logging on with 'as sysdba' http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid537004_tax285650,00.html DB2: Displaying search results on a Web page http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid537734_tax285651,00.html Oracle: Maximun number of columns for a composite primary key http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid537039_tax285650,00.html DB2: Does DB2 have the bit datatype? http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid537737_tax285651,00.html More expert answers here: http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= AVAILABILITY AND CLUSTERING | SearchDatabase.com Featured Topic If you DBAs haven't yet reached the 'five nines' (99.999% uptime) for your mission-critical databases, you'll need the tips, tutorials, webcasts, and news analyses inside... >> CLICK for our current Featured Topic... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci839738,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."
