=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SEARCHDATABASE.COM | Database Administrator Tips November 28, 2001
Essential tools and advice for the enterprise DBA: http://searchDatabase.techtarget.com/tips/ =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - SQL Server Tip: String manipulation functions - Oracle Tip: Procedure for changing foreign keys - SQL Server Tip: Join the results of a stored procedure in T-SQL - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Featured Topic: Is certification worth the pain? - Online Event: Pascal on denormalization - Featured Book: "Oracle9i Instant PL/SQL Scripts" - New newsletter: Oracle tips ___________________________________________________________________ ******************* SPONSORED BY: Software AG ********************* Transform your knowledge with the power of X. Learn from the experts at Software AG's XML Academy. Courses are fast-paced, up-to-date and geared to your needs by the market leader in XML. Sign up today! http://ad.doubleclick.net/clk;3631618;5058249;m?http://www.softwareagusa.com/TTDDNAC __________________________________________________________________ STRING MANIPULATION FUNCTIONS | by Baya Pavliashvili Manipulating string data is one of the most common requirements while working with SQL Server. The good news is that there are number of built-in functions that help us along the way. This article introduces you to a few string functions and demonstrates a real-world solution that takes advantage of them. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci783639,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= PROCEDURE FOR CHANGING FOREIGN KEYS | by Sergey Gerasimov An Oracle package that will create a script to change foreign key options. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci783617,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= JOIN THE RESULTS OF A STORED PROCEDURE IN T-SQL | by H.R. Gorla There are instances when you have to join the results of a SQL Server stored procedure with another query. Here's how to do it. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci783626,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS TRACKING DATABASE TABLESPACE GROWTH | by David Busfield http://www.searchDatabase.com/tip/1,289483,sid13_gci781366,00.html In many situations, an Oracle DBA is required to monitor the space allocations on many databases. A great deal of time may be spent in executing the commands to ascertain the current amount of the allocated space. There is no convenient tracking of the growth without placing the data into some type of report. The scripts provided here will allow tracking of growth for an Oracle database, and flag possible error conditions before they occur. Additionally, the data can be reported as statistics, by the DBA, to keep management informed of growth, plot expected growth, and document the requirement to obtain additional storage hardware. DROP ALL USER-CREATED INDEXES OF A GIVEN TABLE | by Sachin Wable http://www.searchDatabase.com/tip/1,289483,sid13_gci781351,00.html Here is a simple SQL Server stored procedure that allows you to drop all user-created indexes of a given table. It takes a single parameter (@objname) and was created using temporary tables. SQL SERVER 7.0 TO 2000 MIGRATION | by Mutlu Dapdelen http://www.searchDatabase.com/tip/1,289483,sid13_gci781346,00.html This tip is a remedy for the failings of Microsoft's new "Copy Database" wizard, which the author claims doesn't work well enough for an efficient SQL Server 7.0 to 2000 migration. He offers a seven-step plan to do the job better. Hundreds more free tech tips submitted by members: http://searchdatabase.techtarget.com/tips/0,289484,sid13_tax281808,00.html Share your knowledge: Submit your own tip and win a DIGITAL CAMERA http://searchdatabase.techtarget.com/tipsPrize/0,289492,sid13_prz773507_cts773500,00.html ___________________________________________________________________ IMPORTANT MESSAGES AND LINKS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= CERTIFICATION: WORTH THE PAIN? | SearchDatabase Featured Topic Database certifications abound, with Oracle, Microsoft, and IBM leading the pack. But what do the experts think about the value of experience versus certification? Is it worth the time and money? More 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 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= LIVE EXPERT Q&A | Integrity implications of denormalization Who: Fabian Pascal When: Dec. 11, 2001 at 1:00 PM EST (18:00 GMT) Industry critic and author Fabian Pascal dissects the common concept of "denormalization for performance." Don't miss this lively introduction to normalization as a logical concept and how it relates to database performance at the physical level. >> CLICK: http://searchdatabase.techtarget.com/onlineEvents/0,289675,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= BOOK OF THE WEEK | Oracle9i Instant PL/SQL Scripts >From the authorized Oracle Press comes a complete guide to developing PL/SQL solutions quickly and easily. Inside, you'll find ready-to-run code and expert techniques with in-depth explanations that will help you understand the behaviors created, and even extend usage through customization. >> CLICK: http://www.digitalguru.com/DigitalGuru/product_detail.asp?Catalog%5FName=Books&Category%5Fname=Oracle&Product%5FId=0072132183&partner_id=77 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= 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.
