SEARCHDATABASE.COM | Database Administrator Tips July 31, 2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FROM OUR SPONSOR:
Attention DBA's - FREE Time Saving Techniques http://searchDatabase.com/r/0,,4800,00.htm?embarcadero =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - SQL Server: Get a random sample of rows - DB2: Problems when installing DB2 UDB V7 on Windows - Oracle: FOLD_STR function to break SQL at given lengths - Oracle: Keep track of dropped objects - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Ask the Experts: Your tough database questions answered - Featured Topic: Your favorite Webcasts - DB2 tips wanted! ___________________________________________________________________ ************* Sponsored by Embarcadero Technologies *************** Attention DBA's: FREE Time Saving Techniques Control all major DB Platforms -- Oracle, Sybase, MS SQL, others -- through *one* powerful interface...build SQL queries more efficiently ... easily edit SQL ... monitor users & queries ... and more with a FREE trial of DBArtisan. Free trialware installs in minutes and includes full tech support. Download Today and receive a complimentary white paper -- "Leveraging Database Expertise". http://searchDatabase.com/r/0,,4800,00.htm?embarcadero ******************************************************************* ___________________________________________________________________ THIS WEEK'S TIPS: GET A RANDOM SAMPLE OF ROWS | Carl Federl There are occasions when a random sample of a query's rows are needed. This tip explains a few possible methods to do this, then gives an example that works with SQL Server 2000: create a view, then create a user-defined function that selects from the view and finally, reference the UDF in the query. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci826649,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= PROBLEM WHEN INSTALLING DB2 UDB V7 ON WINDOWS | Gert van der Kooij Have you run into problems when installing DB2 UDB V7 on non-English editions of Windows NT/2000? Here's how to deal with "The logging process from a DLL cannot be started. Some error messages can be lost." error. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci837799,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FOLD_STR FUNCTION TO BREAK SQL AT GIVEN LENGTHS | Dilbagh Singh This Oracle script is designed to create a function that breaks/folds a SQL string into multiple lines of a given length without any syntax errors. Lines are broken at a location that provides a syntatically correct SQL statement for direct cutting/pasting. The function has been tested on Oracle 8.1.7.3 Enterprise Edition. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci841568,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= KEEP TRACK OF DROPPED OBJECTS | Rajasekhara Rao Aluru This Oracle procedure gives information about the objects being dropped from a database, such as the name and type of the object, the user who is dropping the object, terminal, etc. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci837900,00.html ___________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= LINKING SQL SERVER 2000 TO ORACLE 8I | Carl Lim http://www.searchDatabase.com/tip/1,289483,sid13_gci840247,00.html Six quick steps to create a Linked Server from SQL Server 2000 to Oracle 8i. STORED PROCEDURE TO DECRPYT ENCRYPTED STORED PROCEDURES | Eli Leiba http://www.searchDatabase.com/tip/1,289483,sid13_gci837799,00.html This SQL Server code presents a stored procedure called sp_decrypt_sp that is used to decrypt T-SQL stored procedures compiled with the ENCRYPTION option. LOG SWITCHES PER DAY/HOUR | Jaco van den Berg http://www.searchDatabase.com/tip/1,289483,sid13_gci835738,00.html Here is an Oracle script that will allow you to view the amount of archived redo logs per day and hour. METADATA API IN ORACLE 9I | Srinivas Chittimalla http://www.searchDatabase.com/tip/1,289483,sid13_gci837903,00.html Users know how difficult it is to get metadata out of Oracle 8i and earlier versions. Fortunately, a new package was introduced in Oracle 9i: DBMS_METADATA. Here are three examples of how to use it. 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 GARMIN ETREX GPS: http://searchdatabase.techtarget.com/tipsPrize/0,289492,sid13_prz836949_cts836948,00.html ___________________________________________________________________ IMPORTANT MESSAGES AND LINKS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ASK THE EXPERT | This week's tough database questions answered DB2: Two-phase commit explained http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid483335_tax285651,00.html SQL: Paging backwards through result sets http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid482962_tax285649,00.html Oracle: Copying the database without the data http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid482549_tax289342,00.html SQL Server: A better way to search http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid482174_tax292506,00.html SQL: Calculating dates http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid482056_tax289340,00.html More expert answers here: http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= YOUR FAVORITE WEBCASTS | SearchDatabase Featured Topic Our Webcasts are high quality presentations by top database experts, complete with PowerPoint slides, audio streaming, and answers to audience questions. By popular demand, here are your all-time favorites on SearchDatabase. >> CLICK for our current Featured Topic... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci841220,00.html >> CLICK for previous Featured Topics... http://searchdatabase.techtarget.com/featuredTopics/0,290043,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= DB2 TIPS NEEDED | SearchDatabase Tip of the Month Contest Attention DB2 DBAs and developers! Share your knowledge, help your peers -- submit a time-saving DB2 tech tip or script. The highest-rated tip in June will win a set of GARMIN ETREX GLOBAL POSITIONING SYSTEM, worth $115! >> CLICK for more info... http://searchdatabase.techtarget.com/tipsPrize/0,289492,sid13_prz836949_cts836948,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."
