SEARCHDATABASE.COM | Database Administrator Tips January 15, 2003 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FROM OUR SPONSOR:
Free database whitepapers http://searchdatabase.techtarget.com/whitepapers3/0,,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - DB2: Checking to see if indexes are needed - SQL Server: Backup and restore, part II: Best practices - Oracle: Find what each Oracle process is doing - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Ask the Experts: Your tough database questions answered - Featured Topic: Backup and recovery ___________________________________________________________________ ****************** Free database whitepapers ********************** Download the key papers you need today to make better-informed decisions. Targeted categories include data analysis and business intelligence, data security, data storage, database-Web integration, and more. Click here to access the free SearchDatabase.com white papers section: http://searchdatabase.techtarget.com/whitepapers3/0,,sid13,00.html ******************************************************************* ___________________________________________________________________ THIS WEEK'S TIPS: CHECKING TO SEE IF INDEXES ARE NEEDED | David Quigley If you have SQL that needs an index but you're unsure about the best index to create, DB2 7 has an index advisory. This quick tip helps a DBA figure out the best indexes to create for a specfic SQL query. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci870110,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SQL SERVER BACKUP AND RESTORE, PART II | Greg Robidoux In the second part of a series, the author presents guidelines that can be used for selecting the appropriate backup and recovery model as well as some important considerations and tips. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci874243,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FIND WHAT EACH ORACLE PROCESS IS DOING | M. Indira Here is a handy script that will correlate the operating system process with the Oracle process. You'll also be able to see the most current SQL run by that process. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci843413,00.html ___________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: REORG AND RUNSTATS IN A KSH SCRIPT | Venkat Arikatla http://www.searchDatabase.com/tip/1,289483,sid13_gci869564,00.html You can reorg and runstats for DB2 with this single ksh script. Install it as a crontab to run every day during off-peak hours. SQL SERVER BACKUP AND RESTORE, PART I | Greg Robidoux http://www.searchDatabase.com/tip/1,289483,sid13_gci872342,00.html One of the most important aspects for a SQL Server environment is ensuring that reliable backups are being executed and a dependable recovery plan is established in the event of a system failure or data corruption. The first part of this two-part article analyzes the various options available for your backup and recovery process with SQL Server 2000. TRUNCATE TABLES USING PL/SQL | Kevin Shidler http://www.searchDatabase.com/tip/1,289483,sid13_gci842566,00.html This script truncates data from tables using PL/SQL for Oracle8i. It first disables all foreign key constraints that would cause the "ORA-02266" error, truncates the tables, and then re-enables all the foreign keys. 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: Finding the 10 greatest numbers in a column http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid511553_tax285651,00.html DB2: QMF versus SPUFI http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid511544_tax285651,00.html Oracle: Loading data from Oracle into flat files http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid508988_tax285650,00.html SQL Server: Improving the search performance though text fields http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid511092_tax292506,00.html SQL Server: Increasing speed of MS Data Engine/SQL Server environment http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid511081_tax292506,00.html More expert answers here: http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= BACKUP AND RECOVERY TIPS | SearchDatabase.com Featured Topic The most important function of a DBA is the backup and recovery of business-critical data. Stay current and informed with our Oracle, SQL Server, and DB2 storage management tip collection, expert advice and news analysis inside... >> CLICK for our current Featured Topic... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci831509,00.html >> CLICK for previous Featured Topics... http://searchdatabase.techtarget.com/featuredTopics/0,290043,sid13,00.html ___________________________________________________________________ *********************SEARCHDATABASE CONTACTS*********************** TIP MAILBOX, (mailto:[EMAIL PROTECTED]) >> Submit your original tip here. 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 ::::::::::::::::::::: 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."