SEARCHDATABASE.COM | Database Administrator Tips February 26, 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 - DB2: Getting started with DB2 application tuning - SQL Server: SQL Server administration dos and don'ts - Oracle: Use autonomous transactions to record to logs - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Free webcasts: BI, data warehousing, DB2 and more - Ask the experts: Your database questions answered - Featured Topic: Database career tips ___________________________________________________________________ ***************** 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, Database Web Integration, and more. Click here to access the free SearchDatabase.com white papers section: http://searchdatabase.techtarget.com/whitepapers3/0,,sid13,00.html ******************************************************************* ___________________________________________________________________ THIS WEEK'S TIPS: GETTING STARTED WITH DB2 APPLICATION TUNING | John Irwin This article looks into some of the steps necessary to locate and tune DB2 application performance problems. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci881905,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SQL SERVER ADMINISTRATION DOS AND DON'TS | Meredith Derby Ignore these simple SQL Server admin tips at your peril! >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci880458,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= USE AUTONOMOUS TRANSACTIONS TO RECORD TO LOGS | Jagadeesh Nooli Here's a quick script that shows you how to write to logs for transactions irrespective of whether the transaction commits or rolls back. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci879431,00.html ___________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: GENERATING UPDATE STATISTICS | Chad Burdette http://www.searchDatabase.com/tip/1,289483,sid13_gci874429,00.html This SQL script for DB2 UDB 7.2 will create a script for running full statistics on databases and provides an output file for updating statistics as needed. RETURN ALL VALUES IN A COMMA-DELIMITED STRING | P. Kulasingham http://www.searchDatabase.com/tip/1,289483,sid13_gci868972,00.html This SQL Server script will return one big string with the rows separated by commas. When getting a set of rows of a field (any string type field), this script could be used to find the field names seperated by commas. QUICKER WAY TO DROP TABLES AND VIEWS IN ORACLE | Mark Hutain http://www.searchDatabase.com/tip/1,289483,sid13_gci878330,00.html ERP application schemas have thousands of tables and views. At the author's company, it was taking a full hour to "Drop User Cascade." By using 1 Drop_master session and 3 drop_slave sessions, the time was cut in half. The procedures in this tip allow multiple sessions to drop tables and views simultaneously. MOVE TABLES BETWEEN TABLESPACES | Sergey Solodilov http://www.searchDatabase.com/tip/1,289483,sid13_gci881048,00.html This Oracle script generates a script that moves tables from one tablespace to another. Also, it rebuildes indexes of these tables and makes an analysis. The script can be fixed for a range of sizes for tables and size extents for new tables. 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: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FREE WEBCASTS | SearchDatabase.com >> Business intelligence with SQL Server http://searchDatabase.com/r/0,,10507,00.htm Microsoft's Bill Baker discusses best practices for implementing a SQL Server business intelligence solution on heterogeneous database systems. >> Impossible data warehouse situations http://searchdatabase.com/r/0,,10092,00.htm Experts Chuck Kelley and Sid Adelman discuss their personal experiences about the realities of data warehousing not covered in basic texts. >> Unraveling the complexities of DB2 stored procedures http://searchDatabase.com/r/0,,9873,00.htm Listen and learn as David Cohn of Themis Inc. provides an overview of DB2 stored procedures on OS/390, the mechanisms for using them, and the SQL/PSM language. >> DB2 test data management revolutionized http://search390.com/r/0,,10220,00.htm Learn how to perform more efficient testing and speed up development. Neal Lozins of SoftBase Systems takes an in-depth look into confronting the challenges associated with test data management. >> Dozens more high-quality webcasts: http://searchdatabase.techtarget.com/webcastsTranscripts/0,289709,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= YOUR TOUGH DATABASE QUESTIONS ANSWERED | Ask the Experts Oracle: What happens to data dictionary, system tables during upgrade http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid518632_tax285650,00.html SQL: Sub-queries in MySQL http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid518537_tax289340,00.html SQL Server: Getting error when dropping, inserting into table with QA http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid518346_tax292506,00.html Oracle: Checking status of a database that has no documentation http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid517413_tax289342,00.html SQL Server: Changing IP address of network http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid517383_tax285648,00.html More expert answers here: http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= DATABASE CAREER TIPS | SearchDatabase.com Featured Topic Even in this dour economy, database administrators and developers continue to be in high demand -- and continue to be highly paid. The collection of tips and advice inside will guide you along the path to becoming a database guru. >> CLICK for our current Featured Topic... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci881884,00.html >> CLICK for previous Featured Topics... http://searchdatabase.techtarget.com/featuredTopics/0,290043,sid13,00.html ___________________________________________________________________ *********************SEARCHDATABASE CONTACTS*********************** 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 2003, All Rights Reserved. ___________________________________________________________________ :::::::::::::::::::: ABOUT THIS NEWSLETTER ::::::::::::::::::::: Published by TechTarget (http://www.techtarget.com) TechTarget - The Most Targeted IT Media Copyright 2003, All Rights Reserved. Unsubscribe from 'Database Administrator Tips' - Simply Reply to this Email with REMOVE 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. - Uncheck the box next to the newsletter you wish to unsubscribe from. - When finished, click "Save Changes to My Profile."
