=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SEARCHDATABASE.COM | Database Administrator Tips October 17, 2001 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
************ Sponsored by VERITAS *************** VERITAS Software Corporation is the leader in essential storage software solutions that enable customers to protect and access their business-critical data. Offering end-to-end storage products and solutions that meet the specific storage management needs of database applications. VERITAS provides customers with tools designed to optimize the performance of their applications, ensure 24x7 availability, and enables cost efficient data management in today's data-driven economy. http://ad.doubleclick.net/clk;3465905;5058249;q?http://www.veritas.com ************************************************* Welcome to searchDatabase.com's Database Administrator Tips newsletter! A whopping four tips submitted by members this time -- check them out online and submit your own: http://searchdatabase.techtarget.com/tips =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= THIS WEEK'S DBA TIPS "Indexed view tips" by Bianca Blount http://www.searchDatabase.com/tip/1,289483,sid13_gci775854,00.html When creating an indexed view in SQL Server, here are several things to take into consideration... "Linking databases across servers" by Chitaranjan Nilak http://www.searchDatabase.com/tip/1,289483,sid13_gci776239,00.html Here is a SQL Server stored procedure that creates a linked server, allowing access to distributed, heterogeneous queries against OLE DB data sources. "A faster alternative to NOT IN queries" by Denise Bossarte http://www.searchDatabase.com/tip/1,289483,sid13_gci775999,00.html There is a better alternative to using "NOT IN" queries. This tip compares a typical NOT IN query to an alternative using outer join notation. But what if your primary key is a composite key? Here are three steps to solve this problem... "Defragmenting Oracle tablespaces" by Tapas Dutta http://www.searchDatabase.com/tip/1,289483,sid13_gci776029,00.html Oracle DBAs often run into problems defragmenting tablespaces, especially the temporary tablespace. This tip includes two scripts to do it efficiently: one for temporary tablespaces, and one for all tablespaces. Share your knowledge: Submit your own tip. The best tipster this month will win a Visor Deluxe PDA! http://searchdatabase.techtarget.com/tipsPrize/0,289492,sid13_prz773507_cts773500,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS "How and why to use CUME_DIST" by Sanjay Raj http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci773679,00.html How and why to use the Oracle analytic funtion CUME_DIST (cumulative distribution), which allows you to pull the top or bottom 20% or 30% (or any other value) from the dataset. "Moving master logins" by Ray Higdon http://www.searchDatabase.com/tip/1,289483,sid13_gci774739,00.html Having a problem trying to migrate SQL Server logins and roles in the master database to a new server? What about migrating them so they are attached to the right databases? Here's how. "Be careful of the LIKE operator" by Hisham Sharifdeen http://www.searchDatabase.com/tip/1,289483,sid13_gci774748,00.html Watch out for this "gotcha" when using the LIKE operator in Oracle. Hint: make sure that the matching character string is not equal to the defined length of the database column. "Restricting IP addresses from Oracle databases" by Sameer Wadhwa http://www.searchDatabase.com/tip/1,289483,sid13_gci770955,00.html Have you ever wanted to control whether or not particular IP addresses can connect to your Oracle database? Here's how... Dozens more free tips submitted by members: http://searchdatabase.techtarget.com/tips/0,289484,sid13_tax281808,00.html Share your knowledge: Submit your own tip. The best tipster this month will win a Visor Deluxe PDA! http://searchdatabase.techtarget.com/tipsPrize/0,289492,sid13_prz773507_cts773500,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SQL TUNING | SearchDatabase.com Featured Topic A slow database is not only annoying to users, it can also affect your company's bottom line. Our collection of SQL tuning tips and expert advice will help you achieve maximal speed and reliability for your DBMS. >> CLICK for our current Featured Topic... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci760320,00.html >> CLICK for previous Featured Topics... http://searchdatabase.techtarget.com/featuredTopics/0,290043,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= BUILDING A METADATA REPOSITORY STEP-BY-STEP | Live Expert Q&A Who : Shaku Atre, President, Atre Group When: Oct 18, 2001 at 1:30 PM EST (18:30 GMT) TOMORROW: The management of "data about data" is critical to a successful data warehouse implementation. Join an industry leader in this Q&A about the seven steps to take when designing an effective metadata strategy. http://searchdatabase.techtarget.com/onlineEvents/0,289675,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ORACLE INTERNALS | searchDatabase.com Bookstore Title: Oracle internals: Tips, tricks, and techniques for DBAs Author: Donald K. Burleson This book is a compendium of the best and most useful articles from Oracle Internals, Auerbach Publications' newsletter for Oracle database administrators and other Oracle professionals. Edited by Oracle guru Don Burleson, it provides the type of in-depth, highly technical information not found in any other book, information only available from peers and consultants. The chapters focus on the truly tough stuff - proven techniques learned in the trenches. You could get this information from other sources, but you'd have to hunt and peck for it. Can you afford that kind of time? Oracle Internals: Tips, Tricks, and Techniques for DBAs gives you knowledge and advice directly applicable to your work in one easy-to-use resource. http://www.digitalguru.com/DigitalGuru/product_detail.asp?Catalog%5FName=Books&Category%5Fname=Oracle&Product%5FId=084931139X&partner_id=77 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= NEW NEWSLETTER | Oracle Tips A brand-new, free monthly newsletter for Oracle DBA's and developers, chock full of advice from the experts and the Oracle community. To subscribe, just login to your account and check off 'Oracle Tips' in the Tips & Columns section. http://searchdatabase.techtarget.com/register/1,,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SEARCHDATABASE.COM CONTACTS TIM DICHIARA, Site Editor ([EMAIL PROTECTED]) >> Send us your original articles and best practices. ED PARRY, News Editor ([EMAIL PROTECTED]) >> Send in your product announcements and poll ideas. GABRIELLE DERUSSY ([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.