SEARCHDATABASE.COM | Database Administrator Tips September 10, 2003 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FROM OUR SPONSOR:
Free database white papers http://searchdatabase.techtarget.com/whitepapers3/0,,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - SQL Server: Split delimiter-separated lists - DB2: DB2 Discovery - Oracle: Selectivity and composite indexes - Oracle: Hidden Oracle, part I: Exploring undocumented utilities - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Free webcast: The future of database administration - Ask the experts: Your toughest DBMS questions answered - Featured Topic: Your DB2 questions answered - Exclusive coverage: OracleWorld 2003 ___________________________________________________________________ ******************** Free database white papers ******************* Download the key papers you need today to make better-informed decisions. Targeted categories include: Data analysis and Business Intelligence; Data Security, Data Storage, Integration, and more. Click here to access the free white papers section: http://searchdatabase.techtarget.com/whitepapers3/0,,sid13,00.html ******************************************************************* ___________________________________________________________________ THIS WEEK'S TIPS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SPLIT DELIMITER-SEPARATED LISTS | Rajasekhar Sahitala This SQL Server function is useful for splitting a string of values delimited by a special character; e.g., a comma or a space. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci915927,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= DB2 DISCOVERY | Barrie Sosinsky Here is a quick introduction to DB2 Discovery, which provides a more automated approach to problems associated with client/server communication. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci928300,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SELECTIVITY AND COMPOSITE INDEXES | Sethuraj Nair Badly ordered composite keys will prevent you from getting the best out of indexing in Oracle. Columns with excellent selectivity at the beginning of the index considerably boost its performance. This script will help DBAs get an idea about the selectivity of component columns of all existing indexes, make a decision about re-ordering the columns in the indexes based on selectivity, and more... >> CLICK for the full tip... http://www.searchOracle.com/tip/1,289483,sid41_gci928040,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= HIDDEN ORACLE, PART I: EXPLORING UNDOCUMENTED UTILITIES Each new release of Oracle brings new hidden utilities. They are sometimes used by internal Oracle development staff and left in Oracle for emergency support. Many of these undocumented utilities are very powerful but can be complex. In this article, Oracle guru Don Burleson describes how to find hidden utilities, executables, parameters, v$ views, system events, and SQL hints. >> CLICK for the full tip... http://www.searchOracle.com/tip/1,289483,sid41_gci928422,00.html ___________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: CHECK THE ISOLATION LEVEL OF ANY SQL SERVER SPID | Paul Wehland http://www.searchDatabase.com/tip/1,289483,sid13_gci920866,00.html How do you check the isolation level of other users (i.e., other SPIDs)? DBCC USEROPTIONS cannot do it. The way aound this is to use the undocumented DBCC PSS command.... USING THE RUN STATISTICS UTILITY | Barrie Sosinsky http://www.searchDatabase.com/tip/1,289483,sid13_gci921669,00.html A short overview of DB2's Run Statistics utility, which is used to collect information about the organization of your table structures. INSERT STATEMENT GENERATOR | Ravi Nookala http://www.searchOracle.com/tip/1,289483,sid41_gci920868,00.html This Oracle script generates INSERT statements from an existing table that can be used as a backup or source script for future data loads. DATA MIGRATION SCRIPT FOR STATIC TABLES | Rajasekhar Sahitala http://www.searchDatabase.com/tip/1,289483,sid13_gci915924,00.html Suppose that you have an application in which you have a table containing static data and you need this data whenever you recreate the database. Using this SQL Server script, you can create a batch of insert statements that you can keep in your database creation script and start using the database after the database creation without reloading any data. A SIMPLE WAY TO REORGANIZE A TABLE AND RELEASE THE UNUSED SPACE http://www.searchOracle.com/tip/1,289483,sid41_gci918141,00.html This tip from member Debajit Mishra describes a simple solution to better manage the table space and performance during ETL operations in Oracle 9i. 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 a prize: http://searchdatabase.techtarget.com/tipsSubmit/1,289485,sid13,00.html ___________________________________________________________________ IMPORTANT LINKS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= THE FUTURE OF DATABASE ADMINISTRATION | Free Webcast SPEAKER: Craig Mullins, Director of Technology Planning, BMC Software WHEN: Available now! Certain trends across the DBMS market today are changing the traditional role of the DBA. Tune in to this webcast and listen as expert Craig Mullins discusses: General industry patterns and specific DBMS market trends, skills essential to a successful career as a DBA today, including Java, .NET and XML, and new demands on the DBA, such as data integration. >> CLICK to listen now... http://searchDatabase.com/r/0,,18754,00.htm =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= YOUR TOUGH DATABASE QUESTIONS ANSWERED | Ask the Experts SQL Server: Building nested tables in SQL Server? http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid551160_tax285648,00.html DB2: Determining if tablespace is segmented http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid551161_tax285651,00.html Database design: Cycle relationships in ER diagram? http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid550713_tax285653,00.html SQL: Combining a LEFT OUTER and INNER join http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid549812_tax285649,00.html SQL Server: File operations from stored procedures http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid549672_tax285648,00.html >> CLICK for other database expert answers... http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html >> CLICK for Oracle-related expert answers... http://searchoracle.techtarget.com/ateExperts/0,289622,sid41,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= YOUR DB2 QUESTIONS ANSWERED | SearchDatabase.com Featured Topic We continue our series highlighting the contributions of SearchDatabase.com's expert panel with DB2 author Craig Mullins. Craig has answered hundreds of your UDB and mainframe DB2 questions. Browse them inside or ask your own... >> CLICK for our current Featured Topic... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci871870,00.html >> CLICK for previous Featured Topics... http://searchdatabase.techtarget.com/featuredTopics/0,290043,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ORACLEWORLD 'O3 IN REVIEW | SearchOracle.com Special Report OracleWorld offered announcements and expert advice that could be pertinent to your Oracle operation. If you couldn't attend, not to worry! We have complete coverage and original analysis inside... >> CLICK for the special report... http://searchoracle.techtarget.com/specialEvents/0,289653,sid41_gci922415,00.html ___________________________________________________________________ *********************SEARCHDATABASE CONTACTS*********************** TIM DICHIARA, Senior Site Editor (mailto:[EMAIL PROTECTED]) ROBYN LORUSSO, Site Editor (mailto:[EMAIL PROTECTED]) SARA CUSHMAN, Assistant Editor (mailto:[EMAIL PROTECTED]) ELLEN O'BRIEN, News Editor (mailto:[EMAIL PROTECTED]) ROB WESTERVELT, News Writer (mailto:[EMAIL PROTECTED]) TOM CLICK, Sales (mailto:[EMAIL PROTECTED]) CLARK MOREY, Sales (mailto:[EMAIL PROTECTED]) ___________________________________________________________________ **********************ABOUT THIS NEWSLETTER************************ Created by TechTarget (http://www.techtarget.com) TechTarget - The Most Targeted IT Media Copyright 2003, All Rights Reserved. ___________________________________________________________________ **********************ABOUT THIS NEWSLETTER************************ Created by TechTarget (http://www.techtarget.com) TechTarget - The Most Targeted IT Media Copyright 2003, 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."
