SEARCHDATABASE.COM | Database Administrator Tips May 22, 2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FROM OUR SPONSOR:
Quest Central(TM)- 14 Day Performance Challenge! http://searchDatabase.com/r/0,,3492,00.htm?FreeTrial =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - SQL Server: Returning a result set in random order - Oracle: Manage archive redo log files - DB2: Find out which DB2 version you are using on MVS - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Ask the Expert: Your toughest database questions answered - Featured Topic: Database wars heat up...again ___________________________________________________________________ ************** Sponsored by: Computer Books Direct **************** Quest Central(TM)-- 14 Day Performance Challenge! Why toggle between products from different vendors? Do it all from one console - Quest Central! Quest Central(tm) is the DBA's integrated console to manage all your critical database environments. Give Quest Central just 14 days and watch application performance skyrocket. Download your FREE trial today at http://searchDatabase.com/r/0,,3492,00.htm?FreeTrial ___________________________________________________________________ ___________________________________________________________________ THIS WEEK'S TIPS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= RETURNING A RESULT SET IN RANDOM ORDER | Baya Pavliashvili At times, you might need to return the SQL Server data to the client in a random order. Unfortunately SQL Server doesn't provide built-in functionality for random sorting of the result set. The good news is that a bit of coding can help you get around this limitation. Here's how. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci823966,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= MANAGE ARCHIVE REDO LOG FILES | Robert Dow Here is a simple Oracle script that the author uses on AIX to manage archive redo log files. This will create a empty tar file, and loop through the available arch log files appending to the tar. Once complete, the tar is compressed. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci821259,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FIND OUT WHICH DB2 VERSION YOU ARE USING ON MVS | David Davis To determine the version of DB2 on MVS you can use the DB2 command: -DISPLAY GROUP The output will include the DB2 Level, which is the DB2 version, release and modification level. >> CLICK for the online version of the tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci824586,00.html __________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= USING THE CHECKSUM FUNCTION TO INCREASE PERFORMANCE | Eli Leiba http://www.searchDatabase.com/tip/1,289483,sid13_gci821254,00.html Suppose you have a SQL Server table with a relatively long string and you want to search on it. An index is not an ideal solution since it will be very big. Here is Eli's suggestion, which works with SQL Server 2000 only... QUICK WAY TO FIND SPACE USED BY EACH TABLE | Parthasarathy Mandayam http://www.searchDatabase.com/tip/1,289483,sid13_gci821478,00.html Here is a quick way to find the disk space used by each table in a SQL Server database. DYNAMICALLY CHANGE NLS_LANG | Ofer Harel http://www.searchDatabase.com/tip/1,289483,sid13_gci821256,00.html When you have Oracle databases with different nls_lang's, you need to change your registry parameters when switching between DBs. Here is a simple way to open SQLPlus window to a database with a particular nls_lang without the need to change the registry. IDENTIFY MISSING FK INDEXES | Prince Kumar http://www.searchDatabase.com/tip/1,289483,sid13_gci821251,00.html Here is an Oracle script that identifies missing foreign key indexes and automatically creates appropriate ones. 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 SAMSUNG DVD/MP3 PLAYER: http://searchdatabase.techtarget.com/tipsPrize/0,289492,sid13_prz805991_cts805990,00.html ___________________________________________________________________ IMPORTANT MESSAGES AND LINKS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ASK THE EXPERT | This week's tough database questions answered Oracle: Finding out how frequently an index is used http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid469061_tax289341,00.html Oracle: Anonymous blocks, RDBMS vs. ORDBMS and REF cursors http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid468727_tax285650,00.html Oracle: Checking free space in dictionary and locally-managed tablespaces http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid468720_tax289342,00.html SQL Server: Triggering an update on one server from another http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid467858_tax285648,00.html SQL Server: Order of WHERE predicates and performance http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid467856_tax285648,00.html SQL: Finding the next customer alphabetically http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid468813_tax285649,00.html More expert answers here: http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= DATABASE WARS HEAT UP...AGAIN | SearchDatabase Featured Topic Who is really king of the $11 billion DBMS hill? Recent data apparently show some surprising changes. Get up-to-date with the latest news and analysis about the ongoing DB2 vs. Oracle vs. SQL Server battle inside... >> CLICK for our current Featured Topic... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci823869,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************************ Created by TechTarget (http://www.techtarget.com) TechTarget - The Most Targeted IT Media Copyright 2002, 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."
