SEARCHDATABASE.COM | Database Administrator Tips June 11, 2003 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FROM OUR SPONSOR:
Attention Oracle DBAs - Free Data Dictionary from Quest Software http://searchDatabase.com/r/0,,14903,00.htm?questsoftware =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - Upgrading SQL Server, part II: Critical upgrade decisions - Oracle: Find full table scans - DB2: Multiple sorts without using dynamic SQL - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Ask the experts: Your database questions answered - Featured Topic: Data center futures ___________________________________________________________________ ***************** Sponsored by Quest Software ********************* Is your Oracle database running at full speed? Can you identify bottlenecks and code that needs tuning? Find out how Quest Software can help with a Database Health Check. Learn more by attending a free live demo of Quest Central(tm) for Oracle. Register today and get a free online Oracle data dictionary: http://searchDatabase.com/r/0,,14903,00.htm?questsoftware ******************************************************************* ___________________________________________________________________ THIS WEEK'S TIPS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= UPGRADING SQL SERVER, PART II: CRITICAL UPGRADE DECISIONS Jeremy Kadlec continues his series detailing the SQL Server upgrade process from the technical, logistical and business perspective. This time, he discusses SQL Server 6.5 to 2000 critical upgrade decisions and redundant upgrade architecture. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci904447,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FIND FULL TABLE SCANS | Sanjay Gupta This tip is useful for identifying all full table scans (FTS) occuring in your Oracle database. Doing a FTS on big tables often causes performance problems. There are many tools available that allow you to select a SQL statement and then present you with the SQL plan; however, when you have thousands of SQL statements and you want to find out only those statements that are going through a FTS, this is a better script. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci893666,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= MULTIPLE SORTS WITHOUT USING DYNAMIC SQL | Jim Haire Have you ever wanted the order of your data sorted differently based on some condition? You could do it by coding multiple cursors or creating dynamic SQL. Here is a way to do it with static SQL and only one cursor. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci903834,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= PL/SQL CONTROL STRUCTURES: BEST PRACTICES | Steven Feuerstein **Note corrected link!** Here are several best practices you should take into account when you work with IF, FOR, WHILE, and GOTO statements in PL/SQL. >> CLICK for the full tip... http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci904096,00.html ___________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: ORACLE SEGMENT STATISTICS | Brian Peasland http://www.searchDatabase.com/tip/1,289483,sid13_gci903793,00.html The V$SEGMENT_STATISTICS dynamic performance view gives many statistics about each and every segment that is used by the Oracle database. Here's how to use it. SCRIPT TO GRANT PERMISSIONS | Parthasarathy Mandayam http://www.searchDatabase.com/tip/1,289483,sid13_gci901507,00.html Here's a simple SQL Server script that can be customized to quickly grant permissions to various users on all tables or stored procedures. Using this script, the author was able to reduce the time taken to grant permissions during installation from 30 minutes to 1 second! DENORMALIZATION OF DB2 TABLES | Craig Mullins http://www.searchDatabase.com/tip/1,289483,sid13_gci903045,00.html Speeding the retrieval of data from DB2 tables is a frequent requirement for DBAs and performance analysts. One way to accomplish this is to denormalize DB2 tables. However, it should be undertaken only when a completely normalized design will not perform optimally. Consider these issues before denormalizing... INTRODUCTION TO ORACLE DESIGN | Dave Ensor & Ian Stevenson http://www.searchDatabase.com/tip/1,289483,sid13_gci903329,00.html Covers what database design is, the various alternative methods and approaches, planning the design phase, and much more. PL/SQL: WHAT, WHEN, AND WHERE | Bill Pribyl & Steven Feuerstein http://www.searchDatabase.com/tip/1,289483,sid13_gci902939,00.html What the Procedural Language/Structured Query Language (PL/SQL) really is, what it is good for, and how it fits into the world. 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: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= YOUR TOUGH DATABASE QUESTIONS ANSWERED | Ask the Experts DB2: Benchmark reports for DB2 and Oracle on OS/390 http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid534671_tax285651,00.html Oracle: Resolving ORA-12560 error http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid533506_tax289342,00.html SQL: Can a table have two primary keys? http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid534350_tax285649,00.html SQL Server: Determining what DTS packages are involviong table http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid533569_tax285648,00.html Oracle: Sequence of user and server processes, instance and session http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid533548_tax285650,00.html More expert answers here: http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= DATA CENTER FUTURES | SearchDatabase.com Featured Topic Our successful conference last week showed how to think about, plan, and implement the data center of the future. Read our coverage of the issues inside... >> CLICK for our current Featured Topic... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci904958,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 '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."
