=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SEARCHDATABASE.COM | Database Administrator Tips October 24, 2001 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
***************************************************************** WHATIS.COM -- Available as a book! "The Whatis.com Encyclopedia of Technology Terms" is now available --more than 3,500 IT terms fully explained. It's a great desktop reference that ensures you'll never be stumped. Free 2-day shipping for all U.S. residents! Find out more at http://whatis.com/WhatisBook ***************************************************************** Welcome to searchDatabase.com's Database Administrator Tips newsletter. We have FIVE member-submitted tips for you this week -- seems like somebody out there wants that Visor PDA we're giving away! Only one week left for this month's contest, so submit your own tip today: http://searchdatabase.techtarget.com/tips =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= THIS WEEK'S NEW DBA TIPS DISPLAY DETAILED INDEX STATISTICS | Cade Bryant http://www.searchDatabase.com/tip/1,289483,sid13_gci777577,00.html Index tuning in Microsoft SQL Server isn't rocket science...It's much, much harder! Here's a simple stored procedure I created called sp_indexstats that allows you to obtain detailed DBCC SHOW_STATISTICS information on all indexes for a given table. WORKING WITH DELIMITED STRINGS IN T-SQL | Harinatha Reddy Gorla http://www.searchDatabase.com/tip/1,289483,sid13_gci777587,00.html Two examples of how to deal with the problems that you may face while working with strings in T-SQL: Finding the count of words in a comma-delimited string, and parsing the delimited string. USING "INITCAP" IN ORACLE AND SQL SERVER | Paul Webster http://www.searchDatabase.com/tip/1,289483,sid13_gci777599,00.html A well-annotated stored procedure demonstrating how to use the Oracle funciton INITCAP. Showing his versatility, Paul has also written the equivalent stored procedure for SQL Server! CHECK FOR ORACLE AVAILABILITY AND TABLESPACE CAPACITY | Rick Stehno http://www.searchDatabase.com/tip/1,289483,sid13_gci777604,00.html A script that will check if all of Oracle instances are up, if any of the extents have reached their maximum limit, and if any of the tablespaces are running short of freespace. GENERATING MAILING LABELS IN ORACLE | Mark Morseth-Mayer http://www.searchDatabase.com/tip/1,289483,sid13_gci777632,00.html An Oracle script that generates mailing labels and mail merge lists to contact individuals or companies. Easily modifiable for your specific needs. ONLY ONE WEEK LEFT! 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 LIKE YOU INDEXED VIEW TIPS | 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 | 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 | 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 | 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. Dozens more free tips submitted by members: http://searchdatabase.techtarget.com/tips/0,289484,sid13_tax281808,00.html ONE WEEK LEFT! 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 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= METADATA AND YOU | SearchDatabase Featured Topic The management of "data about data" is critical to any successful data warehouse implementation. If you're building a centralized or distributed repository, we have the metadata advice, tips, and tutorials you need inside... >> CLICK for our current Featured Topic... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci776449,00.html >> CLICK for previous Featured Topics... http://searchdatabase.techtarget.com/featuredTopics/0,290043,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. 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.