=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SEARCHDATABASE.COM | Database Administrator Tips December 12, 2001
Essential tools and advice for the enterprise DBA: http://searchDatabase.techtarget.com/tips/ =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - Oracle Tip: Analyze and fix core advanced replication problems - SQL Server Tip: Read a text file from the Windows system - DB2 Tip: How to generate dynamic RUNSTATS statements - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Featured Topic: The dangerous illusion - Win a XBox! - New newsletter: Oracle tips ___________________________________________________________________ ********************* SPONSORED BY: VeriSign ********************** FREE E-COMMERCE SECURITY GUIDE from VeriSign--Want to kick your online sales to the next level--while protecting your company from online fraud? And do it QUICKLY, AFFORDABLY and SECURELY? Get your FREE copy of "How to Build an E-Commerce Web Site," today: http://ad.doubleclick.net/clk;3699740;5058249;w?http://www.verisign.com/cgi-bin/go.cgi?a=n095155740616000 __________________________________________________________________ =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= THIS WEEK'S TIPS =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FIX CORE ADVANCED REPLICATION PROBLEMS | by Kevin Nicholson This impressive Oracle script -- created in the Bourne Shell on HP-UX 11.0 -- is intended to analyze, report and fix problems associated with Core Advanced Replication. It is an interactive script that can fix and report the status of advanced replication on a one-way basis. The list of replication directions you can fix is dynamically updated depending on how many databases you have in your repgroup. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci784886,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= READ A TEXT FILE FROM THE WINDOWS SYSTEM | by Eli Leiba Here's a quick script that will read a text file from the Windows system into SQL Server. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci785887,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= HOW TO GENERATE DYNAMIC RUNSTATS STATEMENTS | by Raul Gonzalez Here is a handy trick to dynamically generate RUNSTATS STMTS using the SQL CONCAT and STRIP functions in DB2. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci784886,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS SUMMARIZED REPORT OF SQL SERVER OPTIONS | by Eli Leiba http://www.searchDatabase.com/tip/1,289483,sid13_gci784577,00.html This SELECT will give you a summarized report for the options selected for ALL the databases on your SQL Server. It's compatible with versions 7 and 2000. ELIMINATING DUPLICATE ROWS FROM A TABLE | by Venkat Arikatla http://www.searchDatabase.com/tip/1,289483,sid13_gci784575,00.html Some quick SQL that eliminates duplicate rows from a table in a DB2 database. THE TOP SIX REASONS TO UPGRADE TO ORACLE 8I | by Eli Leiba http://www.searchDatabase.com/tip/1,289483,sid13_gci783971,00.html Still using Oracle 7 or 8 and wondering whether or not to upgrade to 8i? In this article, Eli discuss the top reasons to upgrade to 8i, which are: Simplified dynamic SQL syntax, bulk binds, the Nocopy option in procedures, the Rollup, Cube, Top N operators, temporary tables, and materialized views. 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 PHILIPS MP3 PLAYER! http://searchdatabase.techtarget.com/tipsPrize/0,289492,sid13_prz785186_cts785185,00.html ___________________________________________________________________ IMPORTANT MESSAGES AND LINKS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= THE DANGEROUS ILLUSION | SearchDatabase Featured Topic Author Fabian Pascal dissected the "dangerous illusion" of denormalizing for performance in a live appearance this week. Check out the archived version and our collection of database design resources below for more info... >> CLICK for our current Featured Topic... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci784012,00.html >> CLICK for previous Featured Topics... http://searchdatabase.techtarget.com/featuredTopics/0,290043,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= WIN AN XBOX -- HELP YOUR PEERS Tell your peers about the valuable tech tips, industry news, and expert advice you get from searchDatabase -- and an XBox Video Game System could be yours. Click here for info on how to win: http://searchdatabase.techtarget.com/referFriendContest/1,290949,sid13,00.html?promo_code=xbox =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FREE NEWSLETTER | Oracle Tips A brand-new, free monthly newsletter for Oracle DBA's and developers, chock full of advice and scripts from the experts and the Oracle community. To subscribe, just log in to your account and check off 'Oracle Tips' in the Tips & Columns section. >> SUBSCRIBE: http://searchdatabase.techtarget.com/register/1,,sid13,00.html ___________________________________________________________________ *********************SEARCHDATABASE CONTACTS*********************** TIP MAILBOX, ([EMAIL PROTECTED]) >> Ideas for new tip content. TIM DICHIARA, Site Editor ([EMAIL PROTECTED]) >> Feedback and original articles. ED PARRY, News Editor ([EMAIL PROTECTED]) >> Product announcements and poll ideas. TOM CLICK ([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 2001, All Rights Reserved. If you no longer wish to receive this newsletter simply reply to this message with "REMOVE" in the subject line. Or, visit http://searchDatabase.techtarget.com/register and adjust your subscriptions accordingly. If you choose to unsubscribe using our automated processing, you must send the "REMOVE" request from the email account to which this newsletter was delivered. Please allow 24 hours for your "REMOVE" request to be processed.
