SEARCHDATABASE.COM | Database Administrator Tips March 5, 2003 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FROM OUR SPONSOR:
FREE WHITE PAPER: Oracle data access from .NET http://searchDatabase.com/r/0,,10994,00.htm?compuware =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - DB2: Dropping a column in DB2 7.2 - SQL Server: Comparing timestamps - Oracle: Automatic coalesce of all tablespaces - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Free webcast: Business intelligence - Ask the experts: Your database questions answered - Featured Topic: The challenge of integration ___________________________________________________________________ ******************** Sponsored by: Compuware ********************** LEARN how you can analyze and debug PL/SQL completely within the Visual Studio environment to save time in development. Get expert advice on accessing and manipulating database objects, without switching back and forth between two separate environments. Now that's a technique you'll want to learn. Read on. REGISTER FOR FREE DOWNLOAD HERE: http://searchDatabase.com/r/0,,10994,00.htm?compuware ******************************************************************* ___________________________________________________________________ THIS WEEK'S TIPS: DROPPING A COLUMN IN DB2 7.2 | Prashant Dahalkar Here is a simple way to drop a column to update your DB2 7.2 databases if you do not use third-party software. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci881687,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= COMPARING TIMESTAMPS | Baya Pavliashvili If you're unfamiliar with the TIMESTAMP data type in SQL Server, be forewarned: its name is rather misleading. The truth is that TIMESTAMP has absolutely nothing to do with date or time. The whys and hows of using TIMESTAMP are outlined in this article. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci876848,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= AUTOMATIC COALESCE OF ALL TABLESPACES | Max Mangoni Coalescing tablespace extents is fundamental when the database contains a lot of fragmentated tablespaces. This simple korn shell script helps to automate cleaning of tablespaces. Using this script, the Oracle DBA can schedule a regular tablespace coalesce (always advisable) without any manual intervention. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci883724,00.html ___________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: GETTING STARTED WITH DB2 APPLICATION TUNING | John Irwin http://www.searchDatabase.com/tip/1,289483,sid13_gci881905,00.html This article looks into some of the steps necessary to locate and tune DB2 application performance problems. SQL SERVER ADMINISTRATION DOS AND DON'TS | Meredith Derby http://www.searchDatabase.com/tip/1,289483,sid13_gci880458,00.html Ignore these simple SQL Server admin tips at your peril! USE AUTONOMOUS TRANSACTIONS TO RECORD TO LOGS | Jagadeesh Nooli http://www.searchDatabase.com/tip/1,289483,sid13_gci879431,00.html Here's a quick script that shows you how to write to logs for transactions irrespective of whether the transaction commits or rolls back. SQUEEZE THE SIZE OF FILES IN A TABLESPACE | Sergey Solodilov http://www.searchDatabase.com/tip/1,289483,sid13_gci879433,00.html This tip decreases the size of files of a tablespace to the bare minimum. It's useful when you have many files in a tablespace and you've moved some tables or indexes into another tablespace, and then you want to decrease the size of the first tablespace. GETTING THE LAST ROW FROM A TABLE | Sunil Bhola http://www.searchDatabase.com/tip/1,289483,sid13_gci840260,00.html Everyone knows that how to get first row from a table but what if you want to get the last row and don't know how many rows are in the table? This query will solve it! 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 WEBCAST | SearchDatabase.com TOPIC: Business intelligence: From inception to implementation SPEAKER: Shaku Atre, author of "Business Intelligence Roadmap" Listen and learn as BI expert, Shaku Atre, discusses the different facets of business intelligence and how they can ultimately help you increase your bottom line. She will explain how to take your BI project from implementation to fruition. Learn about: * The major components of BI application development * The vendor landscape * The six stages of a BI implementation >> Listen now: http://searchDatabase.com/r/0,,10861,00.htm >> Dozens more high-quality webcasts: http://searchdatabase.techtarget.com/webcastsTranscripts/0,289709,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= YOUR TOUGH DATABASE QUESTIONS ANSWERED | Ask the Experts Oracle: Workaround for the ORA-4091 error when checking ranges http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid519712_tax289341,00.html SQL: Group aggregates as fractions of overall aggregate http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid518531_tax285649,00.html SQL Server: An easy way to move T-SQL to Java? http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid518349_tax292506,00.html Oracle: Disabling and enabling triggers http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid519706_tax289342,00.html SQL Server: Why is the stored procedure looking for the temp table? http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid517390_tax285648,00.html More expert answers here: http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= THE CHALLENGE OF INTEGRATION | SearchDatabase.com Featured Topic Studies have shown that most modern corporations have from three to ten different DBMS products. Learn more about this complex and growing problem and how integrated systems can provide business value. >> CLICK for our current Featured Topic... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci858799,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. To unsubscribe from 'Oracle 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."