SEARCHDATABASE.COM | Database Administrator Tips June 19, 2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FROM OUR SPONSOR:
Space Management for DB2 - FREE TRIAL http://searchDatabase.com/r/0,,4076,00.htm?FreeTrial =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - SQL Server: Extracting field information from SQL Server - SQL Server: Sending mail from SQL Server using any SMTP server - Oracle: Automatically delete archive logs - Oracle: How to query using special characters - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Free webcast: Developing very large databases with SQL Server - June Training Special: Oracle storage architecture - Featured Topic: Database certifications - DB2 tips wanted! ___________________________________________________________________ ********************** Sponsored by: BMC ************************** ***Space Management for DB2 - FREE TRIAL*** Effectively improve database performance... and go home a hero. With the intelligent space management capabilities of Space Expert for DB2 UDB from BMC Software, identifying and reorganizing your most active objects is done easily and automatically. Save the day and ensure the availability of your mission-critical data with the most intelligent space management solution available! Click here to download a FREE 30-day trial of Space Expert for DB2 UDB: http://searchDatabase.com/r/0,,4076,00.htm?FreeTrial ___________________________________________________________________ ___________________________________________________________________ THIS WEEK'S TIPS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= EXTRACTING FIELD INFORMATION FROM SQL SERVER | Kenneth Moser Ever wonder how to generate a Word document containing all the tables, their fields, datatypes, length, and their primary keys? Here's how to do it in tabular form, automatically, with a single T-SQL command. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci831498,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SENDING MAIL FROM SQL SERVER USING ANY SMTP SERVER | Brian Ferguson This set of stored procedures will 1) send e-mail to a comma-delimited list of e-mails (7000 character maximum), 2) optionally carbon copy a comma-delimited list of e-mails (7000 character maximum), and 3) provide support for a 7000 character body and 255 character subject using any SMTP server. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci827377,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= AUTOMATICALLY DELETE ARCHIVE LOGS | Alex Ivascu Here is how to automatically delete archive logs every so many days, for Oracle databases running in archivelog mode. This was tested on a Windows 2000 Server running Oracle 8.1.7.x. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci826569,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= HOW TO QUERY USING SPECIAL CHARACTERS IN ORACLE | Amit Prashant A short tip demonstrating how to query an Oracle database with special characters, using the percent (%) symbol as an example. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci827190,00.html __________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= REPLACING NON-ALPHANUMERIC CHARACTERS IN STRINGS USING T-SQL | Harinatha Reddy Gorla http://www.searchDatabase.com/tip/1,289483,sid13_gci827318,00.html 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. ANOTHER WAY TO FIND SPACE USED BY TABLES | Guillermo Maldonado http://www.searchDatabase.com/tip/1,289483,sid13_gci826535,00.html A method for retrieving the space used by all SQL Server 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. FETCHING THE NTH HIGHEST RECORD | Ravi Gulati http://www.searchDatabase.com/tip/1,289483,sid13_gci831501,00.html Here is a quick Oracle SQL query that will display the Nth highest record in a table. GENERATING DMP FILES WITH THE DATE UNDER UNIX | Dilip Dandekar http://www.searchDatabase.com/tip/1,289483,sid13_gci831490,00.html This set of three short Oracle scripts will generate, compress, and export dmp files with the date in the name. 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 ___________________________________________________________________ IMPORTANT MESSAGES AND LINKS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= DEVELOPING VERY LARGE SQL SERVER DATABASES | Free Webcast On June 26th at 1 pm (EDT), Brian Goldstein, head of Microsoft's SQL Server Scalability Team, will discuss the VLDB projects that his team has done, including best practices and lessons learned. Join us for this free webcast and take advantage of a rare opportunity to get your VLDB and SQL Server questions answered... >> CLICK to pre-register... http://searchdatabase.techtarget.com/onlineEvents/0,289675,sid13,00.html >> CLICK for 60+ previous Webcasts... http://searchdatabase.techtarget.com/onlineEventsTranscripts/0,289709,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ORACLE STORAGE ARCHITECTURE | June Training Special Oracle DBAs: Get the necessary knowledge and skills to manage data storage with the "Oracle Storage Architecture" training disk. Now save $24.00 when you buy the CD-ROM. >> CLICK here... http://learn.serebra.com?s=33&I=WT1050&m=db610nl&p=c&t=o =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= DATABASE CERTIFICATIONS | SearchDatabase Featured Topic Database certifications abound, with Oracle, Microsoft and IBM leading the pack. Are they a luxury or a necessity in this dour economy? Certification and other career advice for aspiring DBAs and developers inside... >> CLICK for our current Featured Topic... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci754839,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 BOSTON ACOUSTICS COMPUTER SEAKERS, worth $120! >> CLICK for more info... http://searchdatabase.techtarget.com/tipsPrize/0,289492,sid13_prz831133_cts831128,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."
