SEARCHDATABASE.COM | Database Administrator Tips June 12, 2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FROM OUR SPONSOR:
Click here now for a FREE trial of Space Expert for DB2 UDB. http://searchDatabase.com/r/0,,3902,00.htm?BMCSoftware =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - SQL Server: Replacing characters in strings using T-SQL - SQL Server: Another way to find space used by tables - Oracle: Fetching the Nth highest record - Oracle: Generating DMP files with the date under Unix - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - DB2 tips wanted! - Ask the Expert: Your toughest database questions answered - Featured Topic: Backup and recovery ___________________________________________________________________ ********************** Sponsored by: BMC ************************** Want to look good and improve the performance of your database at the same time? With failure-point identification, proactive prevention of space management problems, and sophisticated analysis of your complete database environment, Space Expert for DB2 UDB from BMC Software has the features necessary for you to achieve peak database performance... and to make you look good. Click here now for a FREE trial of Space Expert for DB2 UDB. http://searchDatabase.com/r/0,,3902,00.htm?BMCSoftware ___________________________________________________________________ ___________________________________________________________________ THIS WEEK'S TIPS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= REPLACING NON-ALPHANUMERIC CHARACTERS IN STRINGS USING T-SQL | Harinatha Reddy Gorla As a follow-up to Harinatha's previous two articles ("Complex grouping of strings in T-SQL" and "Working with delimited strings in T-SQL"), here are two important methods for replacing non-alphanumeric characters in strings. Method #1 uses a table of ASCII code values, and method #2 uses specified patterns. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci827318,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ANOTHER WAY TO FIND SPACE USED BY TABLES | Guillermo Maldonado A method for retrieving the space used by all tables, using the output of the stored procedure sp_spaceused and inserting it in a temporary table. There is no need to modify any stored procedure and it has a clean output. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci826535,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FETCHING THE NTH HIGHEST RECORD | Ravi Gulati Here is a quick Oracle SQL query that will display the Nth highest record in a table. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci831501,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= GENERATING DMP FILES WITH THE DATE UNDER UNIX | Dilip Dandekar This set of three short Oracle scripts will generate, compress, and export dmp files with the date in the name. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci831490,00.html __________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= CREATE DAILY REPORTS USING SQL MAIL | Parthasarathy Mandayam http://www.searchDatabase.com/tip/1,289483,sid13_gci827376,00.html At times, SQL Server developers may inadvertently create a database object without prefacing the object name with dbo. The result is that the database object will be owned by the database user, which the developer is using for the connection. To help alleviate this problem, to assist developers, and to orient new database developers to this standard way of development, use SQL Mail to create daily reports for non-dbo-owned database objects. Here's how. HOW TO RUN TWO OR MORE DATABASES IN DIFFERENT TIME ZONES ON THE SAME MACHINE | Rajeev Nadimpalli http://www.searchDatabase.com/tip/1,289483,sid13_gci826633,00.html An explanation of how to run two or more Oracle databases in different time zones on the same Solaris machine. Hint: the method uses multiple listeners. CREATING A LINK FOR CONNECTING TWO DATABASES | Shailesh Yagnik http://www.searchDatabase.com/tip/1,289483,sid13_gci826602,00.html Here is how to create a link so that users can get results from two Oracle databases in one SQL query. 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 BOSTON ACOUSTICS SPEAKERS: http://searchdatabase.techtarget.com/tipsPrize/0,289492,sid13_prz831133_cts831128,00.html ******************************************************************* ---------- June Training Special: SQL Data Management ------------- ******************************************************************* Save 25% when you order the course "SQL Data Management" on CD-ROM. Learn SQL commands for manipulating data and commands to define tables, views and indexes. June special -- get this course for only $75. Click here: http://learn.serebra.com?s=33&I=FC480&m=db610nl&p=c&t=o ******************************************************************* ___________________________________________________________________ IMPORTANT MESSAGES AND LINKS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= 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 BOSTON ACOUSTICS COMPUTER SEAKERS, worth $120! >> CLICK for more info... http://searchdatabase.techtarget.com/tipsPrize/0,289492,sid13_prz831133_cts831128,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ASK THE EXPERT | This week's tough database questions answered DB2: Using LIKE to search for names http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid473901_tax285651,00.html Oracle: Version numbers explained http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid474471_tax289342,00.html SQL Server: Full text queries in SQL Server 6.5 http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid474599_tax285648,00.html SQL: Trying to find the SQL92 and SQL99 specifications online http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid473888_tax285649,00.html Data warehousing: Matching data in databases across the country http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid473915_tax288372,00.html More expert answers here: http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= BACKUP AND RECOVERY | SearchDatabase Featured Topic The most important function of a DBA is storage management: the backup and recovery of business-critical data. But how do you keep up with emerging technologies such as DAS, SAN and NAS? We have the answers you need 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************************ 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."